T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• Need help in select query

  Hi All, I have table of data as follows: 20278123 20278123 20278123 20329456 20329456 20329456 2042…

  borra2005

  2 replies

  15 years, 4 months ago

  By: borra2005

• Check if column exist before selecting values

  Hi, I have a query that is run against several tables and databases. I check if a column exist in a…

  Patrick Veilleux

  3 replies

  15 years, 4 months ago

  By: Toby White

• Alter table on-the-fly

  Hi I need to automate the table update process where a table is imported from a production snapshot…

  Trybbe

  13 replies

  15 years, 4 months ago

  By: Trybbe

• convert whole no. to float

  Hi Frenz I have a list of patient count by month and they are whole nos. Month Pat_count 1 …

  Nuts

  4 replies

  15 years, 4 months ago

  By: Nuts

• SQL Server being hammered by failed login attempts

  I have a SQL Server open to the internet which various of my clients connect to remotely. I've noti…

  hein-1120388

  29 replies

  15 years, 4 months ago

  By: hein-1120388

• Add records together

  I'm doing a query and I should know how I do this, but I just can't think of it right now. So, I'm…

  jordon.shaw

  2 replies

  15 years, 4 months ago

  By: jordon.shaw

• Update, Insert, Delete with Indexes -> Waits, without indexes -> nowaits

  Hi guys, Let's say a have that I have a table that is queried by an SQL (select with some joins) in…

  christian_t

  5 replies

  15 years, 4 months ago

  By: Elliott Whitlow

• Running a shell command in xp_cmdshell as Administrator

  Hi all I've searched quite a bit but can't find anything that can help me on this. I need to stop a…

  hein-1120388

  16 replies

  15 years, 4 months ago

  By: hein-1120388

• Job failure based on value returned from script

  I have a job that I need to execute a test before running. The test is basically to check the data …

  Daniel Bowlin

  3 replies

  15 years, 4 months ago

  By: Daniel Bowlin

• datatype for alphabets

  Hi, Is there any datatype to support only alphabets? Can we achieve that through any constriaints? …

  Rechana Rajan

  7 replies

  15 years, 4 months ago

  By: Dohsan

• Insert with a Select and an Exists

  I have a table MAINT_REQ in which I want to insert values. I want 'mary' to have all of the same ro…

  Rog Saber

  7 replies

  15 years, 4 months ago

  By: Paul White

• Statistics question: Rolling window graph

  I'm a bit stuck - statistics isn't my strong point. I want to create a report of a single column at…

  Tom257

  6 replies

  15 years, 4 months ago

  By: Paul White

• using try/Catch in SLQ SERVER 2008

  I have two StoredProcedures SP1,SP2.In both StoredProcedures,I am using Try/Catch structure for cat…

  Aspet Golestanian Namagerdi

  6 replies

  15 years, 5 months ago

  By: Paul White

• How to encrypt/Decrypt Data

  Hi Please help me. I want to do encryption/Decyption, i am giving examples Example: http://www.g…

  komnaz

  3 replies

  15 years, 5 months ago

  By: Lowell

• Each GROUP BY error message when there is no literal?

  Hi Can i have someone look at this and figure out why its giving this error: Msg 164, Level 15, Sta…

  BIMind

  4 replies

  15 years, 5 months ago

  By: BIMind