SQL Server 2016 - Development and T-SQL

• Topics

  Started by

  Posts

  Last post

• Store multiple strings efficient in sql

  I have 157 values (varchar) in a table but I am only interested in say 50 of these strings. So it's…

  NikosV

  3 replies

  7 years, 5 months ago

  By: NikosV

• Invalid Metadata/Precision error

  I'm writing a query and getting this error. I've written other queries on the same database but not…

  dcotterman

  18 replies

  7 years, 5 months ago

  By: sgmunson

• Within SSMS what are the permissions a user has.

  I can see the user name, but do not know by which 'group' the user gets his/her permissions. The us…

  ben.brugman

  4 replies

  7 years, 5 months ago

  By: ben.brugman

• SQL Like ( not beginning with )

  Hi ,  I am trying to do a pattern search and my query is generic and it uses LIKE .The require…

  savioceg

  16 replies

  7 years, 5 months ago

  By: eshults5

• Running Totals

  DELETED ...

  HappyGeek

  2 replies

  7 years, 5 months ago

  By: HappyGeek

• Get session id/connection id that created global temp/temporary table

  Hi, I need to find out the session id/connection id that created currently existing global temp/te…

  adriano 78610

  4 replies

  7 years, 5 months ago

  By: andycadley

• Intermittent sql_variant problem on COMPATIBILITY_LEVEL >= 120

  I have encountered a reproducible but intermittent problem when working with sql_variant values in …

  David Rueter

  7 replies

  7 years, 5 months ago

  By: siggemannen

• Convert RTF to varchar

  Hi Everyone,     I was wondering if anyone knew of a way to convert an RTF fiel…

  meichmann

  4 replies

  7 years, 5 months ago

  By: meichmann

• Connection properties save location

  Possibly a bit off topic, but does anyone know where the properties are saved when you create a con…

  MikeRen

  8 replies

  7 years, 5 months ago

  By: MikeRen

• How to insert a line break in a SQL Server VARCHAR/NVARCHAR string

  Hi ALL, My table one column have a string like'Hai,Hello,How are you,Hai all' but when we select th…

  polo.csit

  7 replies

  7 years, 5 months ago

  By: Eirikur Eiriksson

• Clustered ColumnStore Index not performing as expected vs Clustered row store?

  Hi,     I am new to this forum and have a question.  We have been evaluating a clust…

  peter.brayton 87020

  1 replies

  7 years, 5 months ago

  By: ScottPletcher

• create cursor in sql

  Hi everyone , I want to create simple update cursor in sql.following sql take almost 1 hour to exec…

  santoshghogare2008

  7 replies

  7 years, 5 months ago

  By: Luis Cazares

• Can we replace Union ALL with single join

  I have two tables tab1 and tab2. Column CDCode on Tab2 table joins with two columns (credit and deb…

  Naidu PK

  6 replies

  7 years, 5 months ago

  By: Naidu PK

• Ideas on Passing filename from script task to data flow task.

  Hi Team, I have a Script task(VB code),I have the output as filename to pick the most recent file f…

  sathwik.em91

  7 replies

  7 years, 5 months ago

  By: Joe Torre

• SQL Server 2016 syntax error

  Hi All, We are in process to upgrade our SQL Server database from SQL Server 2008 to SQL Server 201…

  yoginraval

  10 replies

  7 years, 5 months ago

  By: Sue_H