Questions tagged as 'sql-server'

Tagged questions
1
answer

How to do a query in SQL that brings a count of some results

Next, I'm developing a query in SQL and the purpose of this query is to count the records that reached the value below 99.7% (I have the data for that already calculated and transformed in seconds) but it is not working, and has returned an erro...
asked by 22.09.2018 / 23:22
0
answers

Is there a limit of simultaneous SQLite PHP connection? [closed]

I currently use Mysql on my server with 50 concurrent connections limit. I thought of using SQL Server which in turn has no concurrent connection limit but is very expensive !! .. So I thought about using SQLlite, but would you like to know i...
asked by 02.09.2018 / 01:06
0
answers

SSDT Error SQL71561 reference not resolved

I created a database project for Azure SQL Database using Visual Studio (SSDT). For now I have only two tables: CREATE TABLE [dbo].[ServiceOrder] ( [Id] INT NOT NULL IDENTITY, [Name] VARCHAR(50) NOT NULL, CONSTRAINT [PK_ServiceOr...
asked by 21.08.2018 / 01:49
0
answers

Select in Millions of SQL Server Records

Good morning, I have a database with more than 11 million records, when I do a select on top of the two tables to bring the records to the query takes a lot, I would like to know how I could improve these performance ... Currently with thi...
asked by 28.09.2018 / 15:56
1
answer

Display message according to condition in query

I'm making the difference between dates, when the designacao_circuito column is the same, and the difference (days) between dt_hr_fecom is < = 10, I need it in Reinc_10_Dias column to write Reincidente =<10 dias...
asked by 16.08.2018 / 14:22
0
answers

Run ALTER on a PROCEDURE that is referenced by another object

I'm trying to change / drop the function [xxxx] according to the code. But I get the following error Msg 3729, Level 16, State 3, Procedure xxxxx, Line 1 [Batch Start Line 15] Cannot ALTER 'dbo.xxxxx' because it is being reference...
asked by 31.08.2018 / 20:23
1
answer

Pass object to a sql server proc

How can I make an SP that receives an object? This is my SP ALTER PROCEDURE [dbo].[sp_alt_funcionarios] -- Add the parameters for the stored procedure here ( @id int, @nome varchar(60) ,@dataNascimento DateTime...
asked by 09.08.2018 / 22:04
0
answers

Column number of supplied values does not mach table definition - SQL SERVER

I have the following problem in the sql server when I put the CASE clause at the end of this line of code: DECLARE @RESULTADO TABLE ( Total INT, GrupoTitulo VARCHAR(255), GrupoChave VARCHAR(255), GrupoNome VARCHAR(255), GrupoOrdem VARCHAR(255)...
asked by 10.08.2018 / 13:49
0
answers

Scan Excel table data and save in SQL Server (Asp.Net MVC 5 C #)

I have an 'input file' that the user will upload the worksheet, I need to check if it is .xlsx or .xls and scan the data of that worksheet. After that, I need to save these items to Sql server. On verifying the extension...
asked by 01.08.2018 / 18:58
2
answers

Connecting to database in amazon

Good afternoon, I have a sqlserver database hosted in amazon, and I can not connect to php, is there any specific way of doing this? I tried the connection this way: <?php $servername = "link do server"; $username = "usuario"; $password...
asked by 23.08.2018 / 19:11