T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• Updating column in SQL

  I currently have a column "Description" which has a zip-code in it in Table 'Client'. I have anothe…

  les.61

  13 replies

  8 years, 11 months ago

  By: Joe Celko

• Re-raise error without the throw statement

  I'm trying to troubleshoot an error message that was returned by a stored procedure. The error mess…

  Stephanie Giovannini

  2 replies

  8 years, 11 months ago

  By: mister.magoo

• Money

  Hi Can someone explain what is money datatype.. select CONVERT(money,'1,0,0,0,0,0,0.0,0,0,1') Regar…

  vmssanthosh

  5 replies

  8 years, 12 months ago

  By: Joe Celko

• Add unique valules to a heap

  I have a large table with duplicate values in all columns. I need to add a column, populate it wit…

  dan-572483

  13 replies

  9 years ago

  By: Jeff Moden

• Searching set of words by ignoring spaces

  Hi i need to find whether a set of words for ex. SET NOCOUNT ON in a text. in text it may be SET …

  SqlStarter

  22 replies

  9 years ago

  By: Jeff Moden

• Add million of records

  Hi all, I have to transfer around 50 million records from one table to another. What should be the …

  sqlenthu 89358

  8 replies

  9 years ago

  By: Jeff Moden

• Getting DB Name from query cache

  Hi all, Hoping to find some help in getting this query to work. I'm trying to merge/join two querie…

  UserRR

  4 replies

  9 years ago

  By: UserRR

• format query result

  i have to write q query which would display result as below: Department Name Salary …

  abhas

  6 replies

  9 years ago

  By: Sergiy

• Is Division by Zero NULL?

  I guess that maybe I'm missing the point for the definition of NULL. I would conclude that division…

  Gregory Hart

  64 replies

  9 years ago

  By: Joe Celko

• How to use Windows Scheduler to run a Simple SQL Batch File?????

  Hi, I want to use Windows Server Task Scheduler to run a SQL command once a day So I setup the belo…

  rkelly58

  9 replies

  9 years ago

  By: rkelly58

• Send rows of data to stored procedure in linked server

  Hi, Please guide me as to how to send set of data to stored procedure in linked server. The scenari…

  saum70

  7 replies

  9 years ago

  By: MMartin1

• Add columns to multiple tables

  I have 5 columns that I want to add to multiple tables (without using dynamic SQL). It seems to me …

  tshad

  15 replies

  9 years ago

  By: ScottPletcher

• the multi-part identifier could not be bound

  This statement gives me : Msg 4104, Level 16, State 1 The multi-part identifier "dbo.EMP.ext" could…

  TryingToLearn

  3 replies

  9 years ago

  By: ChrisM@home

• Partition switch giving error

  Hi guys, I have a partition function as Create partition function partfunct_test(date time) as ran…

  sqlenthu 89358

  7 replies

  9 years ago

  By: Gail Shaw

• questions about sql

  hi i have following questions : (1)how to find nolock? (2) can a table have only non cluster index?…

  coool_sweet

  15 replies

  9 years ago

  By: Jeff Moden