Questions tagged as 'sql-server'

Tagged questions
0
answers

'SET ANSI_WARNINGS ON' Laravel 5.4

I'm using Laravel 5.4 with 2 connections, one of them is just to access some Views of a Sql Server bank, and one of them does a LINKED SERVER which forces me to set some settings before making a query. p> Today I can do this in my Controller a...
asked by 09.05.2017 / 18:30
1
answer

CHECKDB found 0 allocation errors and 0 consistency errors in database sql server found 0 allocation errors and 0 consistency errors in database

A few days ago, I had a problem with consistency errors with a database. It has very strange behavior after it is corrected, when I run CHECKDB found 0 allocation errors and 0 consistency errors in database , it does not show me errors,...
asked by 18.04.2017 / 12:16
1
answer

Assign a cursor value to a table column

I have a cursor. I need in an insert to insert the value of each cursor position to a table. How do I do this? I need to insert the value of the exame_cur cursor. My code below: set nocount on declare @id_xfc int, @id_exm_rea int, @id_...
asked by 24.04.2017 / 17:44
1
answer

Connect Sql Sever bank with PHP on windows 10

I am not able to connect to the SQL server database through PHP. I already downloaded the correct driver for the PHP version (php_pdo_sqlsrv_54_ts.dll) and moved it to the ext folder, set up php.ini to load the driver (extension = php_pdo_sqlsrv...
asked by 20.03.2017 / 17:19
3
answers

Export query result as insert scripts

I would like to export the result of a query in SQL Server as an insert script to insert the data into another database. I know there is an option to export the whole table from the menu "Tasks -> Generate Scripts" but I do not want to export...
asked by 04.04.2017 / 13:47
1
answer

How do I make multiple columns in one table refer to a foreign key in another table?

How do I make multiple columns in one table refer to a foreign key in another table? I want all columns called "SLOT", POSSAM to store a table key mods. NOTE: I'm using the latest version of NETBEANS I do not know if this makes any difference...
asked by 01.03.2017 / 02:56
0
answers

Output bandwidth server MS SQL

I have an MS SQL server, with 14 databases, ranging from 2mb to 20gb. The network's traffic output is around 92GB / day. I wonder if there is any way I can monitor to know: Which databases most consume this traffic. Which queries gen...
asked by 20.04.2017 / 20:20
0
answers

Return value DataLayer [closed]

Good afternoon. I have a procedure that does some commands and returns 0 = success; 1 = unsuccessful; alter PROCEDURE [dbo].TesteRetorno ( @DS_NOME_ARQUIVO_SINCRONISMO AS VARCHAR(200) = null ) AS if exists(select...
asked by 27.07.2017 / 18:57
0
answers

How to join 3 queries of different record amounts?

I need to merge 3 queries with results and quantities of different records into a single query, using the Where end of the script as where for all queries . How can I do this? I have tried Union , but it does not run, displaying error...
asked by 17.02.2017 / 15:46
1
answer

Import Backup and Differential Sql Server

I'm having a problem importing a backup to the secondary server: The topology: Production Server > > Contingency server. When importing Full Backup, it imports without any problems. The problem occurs when I import Differential Backu...
asked by 23.01.2017 / 20:47