T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• Two SQL Staatements different results

  Got a feeling this is something to do with an implied cast that I dont understand declare @DataRead…

  Ells

  2 replies

  13 years ago

  By: Ells

• Trigger to delete old data before Insert

  Hi guys .. i am trying to create Trigger on sql 2000 . creating trigger which deletes old data mor…

  SQlLogic

  2 replies

  13 years ago

  By: Sergiy

• While Loop/ CTE Statement

  Hi I have a table, PR_LINK_INV_HST, and I need to find all the records on PR_LINK_INV_HST where the…

  hoseam

  1 replies

  13 years ago

  By: mickyT

• Is there any native support available for JSON in SQL SERVER ?

  Is there any native support available for JSON in SQL SERVER ? ie. Is there any inbuilt tools in SS…

  SQL Kidu

  4 replies

  13 years ago

  By: Lynn Pettis

• not exists versus not in

  Looking at the 2 statements should they not return the same? select *,'I' from pharmdb.pat.dbo.pati…

  timscronin

  2 replies

  13 years ago

  By: Lynn Pettis

• Select statement using a max

  Hi i hope someone can help mw out I have the following selct statement that is working fine Selec…

  mark.doyle

  2 replies

  13 years ago

  By: HowardW

• UPDATE statement help

  Morning guys, I need a lil help with an update query... I have a working table that has all these c…

  asm1212

  3 replies

  13 years ago

  By: Geoff A

• Difference between cursor and While loop

  Hi all, Can any one explain me What is the difference between Cursor and While Loop? I have read…

  $t@r

  4 replies

  13 years ago

  By: Sean Lange

• Order By in Sql Server

  Hi All, In a table i want to apply order by. My database is 20-20 and table is errorreport where I …

  niladri.primalink

  3 replies

  13 years ago

  By: ChrisM@Work

• Interview Questions

  Hi I am facing following interview questions. table i am having one column .That column reco…

  vs.satheesh

  2 replies

  13 years ago

  By: vs.satheesh

• Generate SSRS Report and then Email Report from a single Stored Procedure

  Can someone please offer assistance? I need to create a Stored Procedure that will generate a SSRS…

  Chris Jackson-371542

  2 replies

  13 years ago

  By: rhoskins

• convert tSQL mySQL to MSSQL

  Hi Guys need some help with converting this part of a query from MySQL, I need to run this on MSSQL…

  Brad Marsh

  2 replies

  13 years ago

  By: Brad Marsh

• tsql query - Count the number of spaces in a string

  How do I write a query that tells me how many spaces (...or any character for that matter) are in a…

  FutureQueryArtist

  21 replies

  13 years ago

  By: Jeff Moden

• Storing dynamic sql

  DECLARE MY_CURSOR Cursor FOR SELECT [DB_NAME],[SCHEMA_NAME],[TABLE_NAME],[COLUMN_NAME] FROM dbo.Da…

  rockstar283

  2 replies

  13 years ago

  By: Sergiy

• How to stop SSMS from adding database name to scripts

  Is there an option to prevent SSMS from adding the Database Name to scripts it generates? For examp…

  tshad

  5 replies

  13 years ago

  By: Ray M