Questions tagged as 'sql-server-2014'

Tagged questions
1
answer

Difference between SQL Server Express versions?

What is the difference between DreamSpark SQL Server Express versions?     
asked by 04.12.2015 / 23:34
1
answer

Generate number using identity

Is it possible to generate a number before writing the record to the database? Use field identity of SQL Server 2014. Work with Delphi Berlin.     
asked by 23.08.2017 / 16:19
2
answers

Time to count records the first time

I'm doing a stress test on an application that I'm developing. I added a few million records to a table, which is what it will take in about 5 years of use. I use Entity Framework. When counting records of a query , it took a long time to occur...
asked by 05.01.2017 / 11:50
1
answer

Change varchar field yyyy-mm-dd hh: mm: ss to date dd / mm / yyyy in SQL Server

Dear, I'm extracting data from a satisfaction survey log, and I'm trying to create a column with the date format, so I can group the days and months into an Excel PivotTable. For more details, follow the field varchar with the date:...
asked by 29.08.2018 / 13:04
0
answers

Search in sql server 2014 with php

I am using Sql Server Express, I have an instance installed in two virtual machines on the server, one of the installed instances is Sql Server 2008 , and the other is the Sql Server 2014 When executing the same query in both instances I h...
asked by 21.06.2016 / 01:27
2
answers

Changing the order of the Sql columns?

Good morning Could you instruct me to change the order of the columns in a table? Example: I have Table IcmsMvaUF in the following order: I'd like to pass the MvaEmpresa column to the first column on the left side of the...
asked by 25.05.2017 / 16:38
1
answer

Insert with two different selects

My insert is not working. insert into t_cmo_oit1980 (id_oit, id_exm_rea) select max(id_oit) + 1 from t_cmo_oit1980, select id_exm_rea from t_cmo_Exame_Realizado where id_exm = 3936 and id_xfc = 39517; go I made a gambi a...
asked by 18.04.2017 / 21:46
1
answer

Improve slow query performance in MS SQL SERVER

Are the indexes incorrect? I'm having a hard time optimizing a query. I had another question for a simpler case that resolved, but in that case I'm not getting a better result. The following query is taking 19 seconds: select top 12 c.cre...
asked by 09.01.2017 / 20:03
2
answers

INNER JOIN + LEFT JOIN

I'm trying to query the data in 4 tables : TAFCBHISTPED = NUPED, DTEMIS TAFGRPROD = CDGRPR, DSGRPR TAFPROD = CDPROD, CDGRPR TAFITHISTPED = NUPED, CDPROD, QTPED My query looked like this: SELECT TAFCBHISTPED.NUPED, TAFCB...
asked by 25.10.2017 / 19:05
1
answer

Debug Proc in database sql server 2014

I use Sql Server 2014. I am having problems in Stored procedure, because when running with certain filters, I get this error:    Message 512, Level 16, State 1, Procedure   SP_CMO_SEL_PORTARIA_INATIVOS, Line 485 Subquery returned more than 1...
asked by 26.04.2017 / 16:12