Questions tagged as 'sql-server'

Tagged questions
1
answer

Error "There is already an object named '#TEMP' in the database"

I am performing a load by using a temporary table in Microsoft SQL Server 2008 . SELECT CAMPO1, CAMPO2, CAMPO3, CAMPO4 INTO #TEMP FROM DADOS In the query, I use the following command, to check if the tem...
asked by 28.01.2016 / 14:51
1
answer

Job to write data from a query to an XML file

I need to write the result of a query in an XML through a job that will run daily scheduled in SQL Server. The procedure already returns the result in XML format with tags, in a variable. I just need to play the contents of this variable in XML....
asked by 07.04.2016 / 15:06
1
answer

Conversion from Oracle to SQLServer

   Context: I currently work on a system that uses the
asked by 04.03.2016 / 18:21
0
answers

Connection database sql server 2008 PDO [closed]

I'm using the following code: try { $con = new PDO("sqlsrv:Server=ip;Database=nome","nome","12345"); $con->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); } catch (PDOException $e) { die ("Erro na conexao com o banco de dados...
asked by 28.12.2015 / 13:55
1
answer

INSERT within clause WITH

I basically learned SQL with PostgreSQL, I am first making use of SQL Server and could not figure out how to do this in it. Let's say I have two tables. The first is a generic transaction table (sales, rentals, bookings, etc.) CREATETABLE[db...
asked by 05.07.2016 / 17:51
0
answers

Catching records in the DataGridView and playing on a label [closed]

Folks, my idea is this, I want to get records in a DataGridView and play on five labels. Each one corresponds to a command, and these labels will change to another record as soon as they are clicked. Example: Label1.Text = "Você gosta...
asked by 03.12.2015 / 03:49
0
answers

Collation does not recognize accent [closed]

I have 2 banks in SqlServer, A bank with collation SQL_Latin1_General_CP850_CI_AS , and another bank named B with collation Latin1_General_CI_AS . At bank A, you import information into bank B. A migration of the...
asked by 22.09.2015 / 22:26
1
answer

RDS AMAZON - Difficulties connecting to the Database

I created a Sql server instance in Amazon, but I can not connect through the Sql Server Management Studio. I get the message:    error 10060   Can not connect to endpoint address, 1433. I'm using the following data: Server name...
asked by 10.09.2015 / 12:45
0
answers

MSSQL - do select form in the result fields do not appear repeated

TheselectIamdoingisthis:SELECTDISTINCTdbo.Entity.ComercialName,dbo.ScheduleStatus.Description,dbo.ScheduleGoal.DescriptionASalias_DSG,dbo.ScheduleType.DescriptionASalias_DST,dbo.Entity.ID,dbo.Schedule.Notes,dbo.Schedule.DATEFROM(dbo.ScheduleRIG...
asked by 19.08.2015 / 17:46
2
answers

Automated Backup in SQL Server Express

In my current scenario I have a Windows service that runs in the background that at a specified time by me, runs a batch / em> and saves it to the dropbox folder. But what happens is that the dropbox is not always allowed to access the i...
asked by 17.08.2015 / 23:57