SQL Server 2016 - Development and T-SQL

• Topics

  Started by

  Posts

  Last post

• Count the occurrence of word in a Resume Table

  I have a table called Resume with columns in Text, Word and PDF format. I enabled Full Text Search …

  shambhavi13

  27 replies

  8 years, 4 months ago

  By: Jeff Moden

• does DATEFROMPARTS() work in 2016?

  am working in dev environment sql server 2012. Need to create a date from 'snapshot month' (6) and …

  polkadot

  5 replies

  8 years, 4 months ago

  By: Gail Shaw

• sql server 2016 - Grant Fritchey

  Hello, Do you know if Grant Fritchey has a book on sql server 2016 yet? Thank you

  arkiboys

  6 replies

  8 years, 4 months ago

  By: Gail Shaw

• Option recompile and temp tables in a proc.

  https://blogs.msdn.microsoft.com/robinlester/2016/08/10/improving-query-performance-with-option-rec…

  MadAdmin

  2 replies

  8 years, 4 months ago

  By: MadAdmin

• Using new GetIdentificationStringByID to get Column Name in SSIS

  I'm using SSIS to load tab-delimited text files into a SQL staging db. Naturally, I'm having to dea…

  lduvall

  16 replies

  8 years, 4 months ago

  By: frederico_fonseca

• explain composite index structure and work? How B Tree for composite index work internally?

  HI Champs, explain composite index structure and work in sql server ? How B Tree for composite inde…

  ravi@sql

  1 replies

  8 years, 4 months ago

  By: Gail Shaw

• TSQL and if it can be done in set

  Hey Experts, This recently came up at work and the solution to the problem was utilizing a loop. I…

  brad.mason5

  6 replies

  8 years, 4 months ago

  By: Umer Akram

• SQL 2016 OPENJSON Array

  Hi, I have a mix of data in a table as follows: person_id interests 1&nbsp&nbsp&n…

  rka

  2 replies

  8 years, 4 months ago

  By: The Dixie Flatline

• TST 1700 If a food product

  TST 1700 If a food product is labeled as fat-free, be cautious about it. These foods may be high in…

  johnvasquez

  1 replies

  8 years, 5 months ago

  By: johnvasquez

• Ltrim not working, not able to remove prefixed "-" from a column.

  Hello, I have a problem, ltrim is not working. Here is the scenario I imported data to a table…

  sanjaydut26

  5 replies

  8 years, 5 months ago

  By: The Dixie Flatline

• Check for Columns in the table and then Execute next Tsql statements

  Hello Everyone, I have a problem, We have different client specific databases with all same Tables,…

  sanjaydut26

  3 replies

  8 years, 5 months ago

  By: Eirikur Eiriksson

• Simple Aggregate function.

  --input code : CREATE TABLE SumPositiveNegative ( ID INT ) GO INSERT INTO SumPositiveNegati…

  Anand BI Developer

  5 replies

  8 years, 5 months ago

  By: Anand BI Developer

• Upgrading SSIS 2008 to SSDT 2016: connection provider is not registered and cannot change Platform to x86

  I'm upgrading an SSIS package from SQL Server 2008 + BIDS to SQL Server 2016 + SSDT. The environm…

  David Data

  6 replies

  8 years, 5 months ago

  By: Phil Parkin

• sql query

  I have week codes like 201551 , 201552 I want the sql query to return firstday and last day for tho…

  sanjayasamantaray

  3 replies

  8 years, 5 months ago

  By: Luis Cazares

• STDistance with SPATIAL INDEX QUERY TO SLOW :)

  hi all, i have to following query : DECLARE @latitude float=31.24326 DECLARE @longitude floa…

  sharon-472085

  7 replies

  8 years, 5 months ago

  By: The Dixie Flatline