Questions tagged as 'sql-server'

Tagged questions
1
answer

Error connecting BD tables

Iamtryingtolinkthelessontabletothefaults.I'musingthe"Licao_Faltas" table to make the connection, but you are not letting me connect the "litas" to "licao_faltas" Help Please.     
asked by 18.01.2016 / 18:02
2
answers

Convert date format sql server

Well, I need to convert the date in the sql server to dd / mm / yyyy I need an update or something that can help me. Picture of the table column below, as it stands now: I need you to stay 03-10-2016 for example.     
asked by 18.01.2016 / 18:18
2
answers

Problems finding table in sql [closed]

When I use o Select * From table_x and I go through my table, SQL does not find the indicated table?     
asked by 25.02.2016 / 21:21
1
answer

SQL Server Transaction Replication - Primary Key

I have an environment with 2 branches, each branch has to have an application server with a SQL SERVER installed, I configured the # that is working perfectly, however if 2 people in different branches are inserting data into the same table at t...
asked by 18.02.2016 / 20:19
1
answer

I can not give a grant in a schema

I'm working with a SQL Server 2012 database and I'm trying to assign a grant to a schema with the following command: GRANT INSERT ON SCHEMA :: trunk TO trunk And I'm having the following error: Cannot grant, deny, or revoke permissions to...
asked by 23.09.2015 / 19:48
2
answers

How to connect PHP 5.6 to Sql Server 2008?

I need to connect to a BD MS Sql Server 2008 with PHP 5.6 I have Development: Windows 7 64bit, with xampp Centos 7 Production I have installed the Microsoft drivers . With this line of code $c = new PDO("sqlsrv:Server=$host;Databa...
asked by 23.09.2015 / 18:52
1
answer

Help with PHP Edit PDO

I'm pulling data from a table in sqlsrv to a table html, because I need to frequently edit this data in that table. So I created a php function edit to edit the table row in another page only that is not working does not return me nor one value....
asked by 11.01.2016 / 14:59
1
answer

Subquery returned more than 1 value. This is not permitted when the subquery follows =,! =, = =

I have a procedure that sends email with the table data, including the email that will be forwarded, but it is sending to only the 1 record, the second it goes straight, and it's in Infinite Loop, sending multiple Emails to just the 1st r...
asked by 28.10.2015 / 14:35
1
answer

Getdata function VB.NET

I'm trying to create a function to update the Datagridview. I added the following code but a "Can not clean list" error Code: Private Sub GetData() Try con = New SqlConnection(cs) con.Open() cmd = New SqlComm...
asked by 11.11.2015 / 18:48
1
answer

Replace problem in sqlserver

I have a field in the page that receives only number, but when I compare in the function this value of the page with what is in the database, it does not return to search. I'm trying to use Replace to strip the formatting of the bank's...
asked by 21.08.2015 / 21:07