Questions tagged as 'sql-server'

Tagged questions
3
answers

How to use the alter table by modifying an attribute for PK and FK?

I have a table Funcionário , where its PK is this Cod_Func . Then I created this table Vendedor , I created the attributes manually, I did not put Cod_Func of Table Vendedor as PK , because this is...
asked by 25.11.2017 / 17:07
1
answer

Is a "Group by" possible for column content?

I was wondering if it was possible to use GROUP BY based on the date of a column, in this case the ANALYSIS column that creates groups whenever it finds 0, instead of the column. DIA MES YEAR TODAY TOMORROW ANALY...
asked by 25.10.2017 / 00:30
1
answer

Update on a column using more than one return

I have to update a given field of a table by subtracting from it the values returned from a select in another table. The problem I am facing is that as select returns more than one value and I have to go subtracting value by value, so I can comp...
asked by 14.11.2017 / 00:05
0
answers

Update table with XML field and on different banks

I have two SQL SERVER 2012 banks installed on server A and server B, I need to insert and then do a Update on the server table B via linkedServer by server A, but in these tables have XML fields, I am not necessarily updating this fie...
asked by 07.12.2017 / 16:23
1
answer

Query with MAX (DATE)

I'm trying to generate the query below as follows. Cliente Tarefa Data da Ultima Providencia Teste 16555 04-07-2017 However, it is generating in a duplicate way, that is, I want to get the last date of the last provisio...
asked by 18.09.2017 / 21:22
0
answers

SQL Server drives recognition for db connection in PHP [closed]

I am having trouble connecting to the SQL Server database. I can not install the drives to be recognized. On the internet I've tried all sorts of things and nothing worked. I downloaded the drives on the Microsoft website, I put it in the php ex...
asked by 01.09.2017 / 15:24
1
answer

SQL to count records that have a repeating value field

Personal I need a Query that does a count of values that I have in the bank On my system, I have a multiselect that can select more than one option. I wanted your help, I never moved with a query, I need a Query that tells me how many numb...
asked by 25.07.2017 / 17:24
0
answers

c # Error: "Object reference not set to an instance of an object"

I'm trying to make a connection to the sql server in a xamarin application for android, but the application has this error:    Object reference not set to an instance of an object Connection class: public class SqlServercon {...
asked by 18.07.2017 / 01:29
1
answer

Problem executing a query on a loop repeat in the Mssql Node

So, I am using node and mssql package (sql-server) to query my database. however I am facing a difficulty to return queries that need to be executed within a loop. Maybe it's something to do with the way I'm performing the callback. In...
asked by 21.08.2017 / 22:06
1
answer

Bank without PK, but mapped PK to Entity. Is that a problem?

I'm having problems with float fields. Well, this post will deal with another subject, but I thought I could somehow infer that problem. I stopped to think and analyze the matter. This bank belongs to the customer and is very old. If someone tel...
asked by 17.09.2017 / 02:57