Stack Overflow
Stack Overflow

Questions tagged [sql-server-2014]

Use this tag for questions specific to the 2014 version of Microsoft's SQL Server database engine. SQL Server 2014 is the predecessor of the later SQL Server 2016.

SQL Server 2014 (codename Hekaton, version 12.00), released in April 2014, is the successor to SQL Server 2012 and the predecessor of the newer version of Microsoft's SQL Server database engine SQLServer 2016.

This tag covers questions specific to the 2014 version of the database engine. It is recommended that the tag is also used when tagging questions with this version specific tag.

Read more about SQL Server 2014 from MSDN.
Get SQL Server 2014 from here.

4735 questions
1
vote
1 answer

Clustered Columnstore Index in SQL Server Standard Edition 2014?

I've made a Database-Project, which was originally supposed to be deployed to an SQL Server Enterprise Edition 2014. Some Tables in the project have Clustered Columnstore Indices. As far as I know, Clustered Columnstore Indices are not supported in…
moons
  • 209
  • 2
  • 12
1
vote
1 answer

How to modify XML node that contains a specific child node value?

I have a table with an XML column. How can I add another node inside a node that contains a child node with a specific value? For example I'd like to copy foo/bar/e/f node from barId 6699 to barId 66989. I only find examples where you select node…
jumxozizi
  • 642
  • 10
  • 21
1
vote
1 answer

Why does replace fail using PATINDEX for certain special characters?

We are trying to strip certain special characters from a string using the (simplified) command below, which is the most common solution we've seen after searching. But, the results are inconsistent when using certain special characters. Can anyone…
LBerg
  • 33
  • 2
  • 8
1
vote
0 answers

Run SSIS package with project params from c# app

I want, as in title, to run SSIS package (which is in SSIS project folder) with project params from c# app. I set a ConnectionString in expressions as: @[$Project::OutputFilePath] +"report.csv". I have such code to run package from c# windows…
Monic
  • 726
  • 10
  • 31
1
vote
1 answer

Which to use: SSISDB executions and event messages versus SSIS package logging?

I know this topic is a bit general but I do have a specific use case. Does the logging utility in SSIS have any specific advantages, or additional information, over the internal logging of the SSISDB? My environment contains packages, which are…
Jacob H
  • 2,455
  • 1
  • 12
  • 29
1
vote
1 answer

TSQL having @varible in a SELECT statement

Hey all here is my code that I currently have in a Stored Proceedure: DECLARE @SQL NVARCHAR(MAX); [more code here.....] SET @SQL = @ParameterSQL; [more code here.....] SET @SQL = 'SELECT CONCAT( …
StealthRT
  • 10,108
  • 40
  • 183
  • 342
1
vote
2 answers

SUM total numbers by day?

If I have a database with two columns, Date and a Number, with multiple Number entries per Date. How can I add a column that shows the total Number for the Date listed? So if I have four entries for 05/09/2017, with values 2, 4, 3, 8, all four…
DoinMyBest
  • 13
  • 3
1
vote
0 answers

SQL Server: Error to import data with umlauts and special characters

I am trying to import this data here with special characters such as ä and ö (umlauts). When I import data in SQL Server Management Studio, I get the following error The output char buffer is too small to contain the decoded characters, encoding…
hhh
  • 50,788
  • 62
  • 179
  • 282
1
vote
2 answers

Why auto update statistics are not efficient to improve the performance

We have a DB of size 1257GB having 100+ objects with hourly transactions (Insert and update). We have set Auto Update statistics:True and Auto Update statistics asynchronously : False. When we trigger the queries to fetch the data it's taking long…
Puneeth Haroor
  • 21
  • 1
  • 1
  • 4
1
vote
1 answer

Split Address field

I have a address column that contains street address along with the PO Box no.I would like to extract street address and postcode into a separate column, how can I do that? Sample Data 1 ABC CDE PO BOX 650 15 N. MAIN STREET P.O. BOX…
mehtat_90
  • 586
  • 9
  • 29
1
vote
1 answer

Comparing records within the same table in SQL Server 2014

I have a table that shows the entry and exit of items into the warehouse. The Camera 1 and Camera 2 document the entry time and exit time respectively of that item. The cameras then classify the item as it enters and leaves the checkpoint with the…
user1777929
  • 777
  • 1
  • 10
  • 28
1
vote
2 answers

DateTime format issue on StoredProcedure - C# ASP.NET x MS SQL Server 2014

I'm facing an issue while running an SQL Server 2014 stored procedure from my C# ASP.NET application (MVC 3). When I manually run this procedure with the same parameters, it returns me all proper results. When the procedure is executed from the C#…
Stefano Guimarães Falce
  • 125
  • 1
  • 2
  • 12
1
vote
2 answers

Looking for a birthdate Range in SQL

I am looking for a birthdate range of march 21 to April 20, and the year doesn't matter. and it seems that when i search other months and date are coming out. select * from AllStudentInfo Where ((MONTH(birthDate) >= 3 and day(birthDate) >=…
GiveChance
  • 47
  • 1
  • 9
1
vote
2 answers

CONCAT in SQL Server 2014

I have a problem when I want to use CONCAT inside my stored procedure. I press execute and get this error message: Mens 195, Nivel 15, Estado 10, Procedimiento upd_agregar, Línea 96' CONCAT' is not a recognized built-in function name. This is my…
Gabriela Zeas Nuñez
  • 37
  • 6
1
vote
1 answer

How to constantly update a database table depending on the time?

I have hundreds of records, all with an expiry datetime column. Something like this: Name Expires Status -----------+---------------------+--------+ Apple1 2017-05-05 10:10:15 Live Apple2 2017-06-01 18:15:03 …
volume one
  • 6,800
  • 13
  • 67
  • 146
1 2 3
…
99
100