SQL Server 2012 - T-SQL

• Topics

  Started by

  Posts

  Last post

• C2 auditing trace files not created on sql server 2012 with alwayson, but are on enterprise edition

  Hi. I was able to find out what was wrong. The sql server service was running with an id that didn'…

  richard.vanveen

  2 replies

  11 years, 9 months ago

  By: richard.vanveen

• Need help with eliminating quotations from my columns when running a query

  Hi Sorry if this is posted in the wrong place. I'm using SQL 2012 express.. and just recently lear…

  elchulito89

  2 replies

  11 years, 9 months ago

  By: Grant Fritchey

• Can recursive CTE solve a Tiering problem?

  Hi, I have a problem that I have a solution for, but I can't help but thinking a recursive CTE (or …

  jsalisbury

  1 replies

  11 years, 9 months ago

  By: Dwain Camps

• Has anyone written a "quiet" version of sp_updatestats around

  Hi All, Has anyone of you written or encountered a version of sp_updatestats that does NOT display …

  Jan Van der Eecken

  3 replies

  11 years, 9 months ago

  By: Jan Van der Eecken

• recursive Stored procedure or function

  is there any way to have a stored procedure or function like below c# code: Comment :"i want to con…

  Eskandari

  8 replies

  11 years, 9 months ago

  By: The Dixie Flatline

• Why the Indexes on table slow down the DML operation on table, what is the exact reason?

  Hi All, Greetings! Why the Indexes on table slow down the DML operation on table, what is the exact…

  Tony1234

  5 replies

  11 years, 9 months ago

  By: Nevyn

• Coalesce - How it works ?

  I googled this code, I cant understand how this convert entire column into single row.. how this a…

  vignesh.ms

  1 replies

  11 years, 9 months ago

  By: Koen Verbeeck

• Need urgent help on developing a query

  This is how data is in the table. Column0 Column1 Column2 Column3Column4Column 5 2013 NULL…

  tarakeswararao.allu

  4 replies

  11 years, 9 months ago

  By: tarakeswararao.allu

• Writing to Windows Event Log using TSQL

  I am able to write to Windows Event Log using xp_LogEvent. My question, is there a way to write, or…

  rerichards

  5 replies

  11 years, 9 months ago

  By: SQLBuddy123

• How it works ?

  hi there, Can anybody help to understand how the following query works ? declare @dynamic_sql as v…

  vignesh.ms

  6 replies

  11 years, 9 months ago

  By: vignesh.ms

• dsplay group

  http://www.c-sharpcorner.com/Forums/Thread/247351/display-sql-table-rows-to-word-or-pdf-like-below-…

  shashianireddy

  2 replies

  11 years, 9 months ago

  By: The Dixie Flatline

• Finding unused stored procedures

  How do you find stale stored procedures ? In a scenario where a developer created a slight modifica…

  j-1064772

  5 replies

  11 years, 9 months ago

  By: j-1064772

• Cannot convert valid Char(24) date/time to date/time data type

  Hi, I have collected some data using TYPEPERF. This command creates tables in the database specifie…

  Dennis Post

  17 replies

  11 years, 9 months ago

  By: Dennis Post

• t-sql self join and use dates

  In a sql server 2012 I would like to join a table to other tables by CustomerNumber. The table call…

  wendy elizabeth

  5 replies

  11 years, 9 months ago

  By: Sean Lange

• Inserting new columns based on the condition!

  Hi guys, I have a very simple query like the following… -------------------------------------------…

  artistdedigital

  7 replies

  11 years, 9 months ago

  By: artistdedigital