Questions tagged as 'sql-server'

2
answers

Match table data on LinkedServer servers

I have 3 LinkedServer servers (the 3 having the same tables with the same fields). Home Server 1: First_Server Home Table: Testing Server2:Second_ServerHomeTable:Testing Server3:Third_ServerHomeTable:Testing Selecttoreturnthefieldsfromthe"Test...
asked by 16.07.2018 / 16:06
2
answers

Update table after Insert to another

I have a table called Consumption, in this table I have a Quantity column. I have another table called Product, in this table I have an Inventory column. Whenever a new consumption is entered, one must choose a product and the quantity that w...
asked by 21.03.2018 / 18:48
1
answer

Return data from 2 tables entity framework

I have the following table: Movement -movement -Indicator -ProductId When I select a particular customer I want to list all of the trades in which they are together with the product. how would I call this inside the controller? That's what...
asked by 07.02.2018 / 00:27
1
answer

order by specific text [closed]

How do I order by by text criteria? I have a column with some classifications and I wanted it to come in the order I determine. Example: 'carro1' 'carro3' 'carro5' 'carro10' 'carro2'     
asked by 12.06.2018 / 21:08
1
answer

Begin Transaction and Save Transaction SQL Server

I have a StoredProcedure on a system I'm working on and I have the following code begin transaction; save transaction Integration_SP; -- CODIGO commit transaction; I've been searching and only found comparisons between BEGIN and SAVE transa...
asked by 28.05.2018 / 13:32
1
answer

Remove "." "/" and "-" from varchar in select

I am conducting a query for a client where he / she requested that the CNPJ / CPF of the companies / clients be displayed without the dots, bars and dashes. For example, the CNPJ 08.595.551/0001-57 should be displayed 08595551000157...
asked by 14.03.2018 / 13:55
4
answers

PDOStatement :: rowCount returns -1

I need to know how many records were entered in the query below. public function CadastraCliente() { $this->conn->beginTransaction(); try { $stmt = $this->conn->prepare(" INSERT INTO SISCli (CdInscricao,...
asked by 24.08.2017 / 17:07
1
answer

Transfer data from SQL Server to SQLite with Android

I have software that is connected to a SQL Server database, but now I'm doing the software on Android using SQLite. I need to transfer the SQL Server database (with data) to my SQLite. Backup works? Even with the views I have in SQL Server...
asked by 10.02.2017 / 06:04
1
answer

___ ___ erkimt Message "Invalid object name 'dbo.table' SQL Server Go Lang ______ qstntxt ___

I'm trying to use a select in my SQL Server Database that I own in Azure.

I'm using the Driver: link .

However, I get a message back:

  

mssql: Invalid object name 'dbo.table'.

Below my code, where am I wrong?

%pre%

Return:

  

C: \ Go \ bin \ go.exe run B: \ go \ gocode \ src \ main \ connect-bd.go
  2017/02/25 15:59:33 Main:
  2017/02/25 15:59:33 Opening
  2017/02/25 15:59:33 Opened
  2017/02/25 15:59:33 Pinging
  2017/02/25 15:59:33 Pinged
  2017/02/25 15:59:33 mssql: Invalid object name 'dbo.tbPessoa'.
  exit status 1

    
______azszpr186720___

In my connect string, I was missing out on which bank to use %code%

Done this connected in a good!

Without this information Select was being done in the default SQL master database.

It looks like this:

%pre%     

___
I'm trying to use a select in my SQL Server Database that I own in Azure. I'm using the Driver: link . However, I get a message back:    mssql: Invalid object name 'dbo.table'. Below my code, where am I wrong? package main impor...
asked by 25.02.2017 / 20:18
2
answers

Perform insert into C # List [closed]

Can one give an example of how an sql insert would be in a list in C #?     
asked by 28.07.2016 / 03:00