Good morning, fine, guys?
Next work with database, and we have some problems with SQL SERVER 2014 x64 in Windows 10. I am doing the installation normally and changing the network configuration, in TCP / IP, to a specific port that we use....
I have installed SQL Server 2014. When I start PowerShell on Windows Server 2008 R2 and do the "sqlps" command to test, this error occurs which shows in the image below ...
On another computer, with windows 7 and the same version of SQL Serve...
Is it possible to create a temporary table that is mirrored in another?
Example: Let's say I have in my bank a table with 60 fields. I would like to create a temp named #tabela with the same structure as the table in the database, but wit...
Let's say I have this block:
declare @teste int
declare teste_cur cursor
for
select campo1 from tabela
.....
while @@fetch_status = 0
begin
set @teste = 0
select @teste = campo1 from tabela where campo2 = condicao2
end
.....
If the sele...
1 - My software in C # with SQLEXPRESS database LocalDB does not open on another PC, even installing all dependencies.
NOTE: In my PC Development works perfectly.
2 - Programs that I have already installed on the Client:
Microsoft SQL Server...
Aguem could help me I'm doing a project to deliver this year in college in 4 layers I have a login screen and when I type user and password I choose the company that I should work example Company A, Company B, Company c, in sql server I have 3 ba...
I created a default database and created some schemas within this database. I created users for each schema, now I want to give full permission to each user in their schema only, how should I do?
Good morning, I have a query that brings in a calculated column the information of "Data" and "Historicos", in this column I have the Prefix of the item (vehicle license plate) and the column with its calculation.
I need to change this query so...