T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• How to decrease Log file size?

  Log file size is increased to 3 GB in production. Can any one suggest me how to decrease log file s…

  banda.sai

  10 replies

  13 years, 10 months ago

  By: Thomas Stringer

• Store Insert, Update, Delete statements in a AUDIT table as any DML operations performed on a table

  Dear All, Hi! I am in a need where I have to store "Insert, Update, Delete" statements in an AUDIT…

  bharat sethi

  4 replies

  13 years, 10 months ago

  By: Rock from VbCity

• for xml path() concatenates texts, how to get 2 elements with the same name?

  select 'A' as [value], 'B' as [value] for xml path('test'), type This outputs the following:…

  R.P.Rozema

  7 replies

  13 years, 10 months ago

  By: R.P.Rozema

• Foreach vs set for Database mail stored proc. Is it possible to send many messages with 1 statement?

  Hi all I am trying to implement a simple warning system using database email. I am monitoring an …

  thepotplants

  9 replies

  13 years, 10 months ago

  By: Jeff Moden

• User access

  Hi Team, We have Two Environments QA and IST. Here we have ABC user we have How Can we check ABC us…

  shiv-356842

  2 replies

  13 years, 10 months ago

  By: Daxesh Patel

• Optimise this ....?

  Hi, I have the following SQL: UPDATE TABLE1 t1 SET Processing_Status = 0 WHERE t1.ID NOT IN (SELEC…

  bleroy

  4 replies

  13 years, 10 months ago

  By: Gail Shaw

• A-Z list

  REVISED Question: I want to return all data (varchar) from a column in a table and have it sorted a…

  barryocteau

  9 replies

  13 years, 10 months ago

  By: MVDBA (Mike Vessey)

• Figuring out NSF payments

  Greetings all. I was posed with what turned out to be a more difficult problem than I had anticipa…

  Greg Snidow

  40 replies

  13 years, 10 months ago

  By: Greg Snidow

• Multiply two columns in SQL nd store

  Hi, I want to multiply two columns in SQL nd store can anybody help me out in this scenario. Exampl…

  best_yunus

  13 replies

  13 years, 10 months ago

  By: vinu512

• correct the code

  hi, i am trying to get 0 as a value if no of rows is 0 still not getting ,my result set is blank. p…

  riya_dave

  9 replies

  13 years, 10 months ago

  By: Dwain Camps

• Bulk Insert Use a format file stored in SQL

  Hi all I have a list of file i want to Bulk insert using the Bulk Insert command. I also have an XM…

  ashley.wardell

  10 replies

  13 years, 10 months ago

  By: Orlando Colamatteo

• SSIS Expression - Looking for the Typo

  I hope someone can help me. This is driving me nuts. I've got a big file that is tilda delimited. W…

  Brandie Tarvin

  1 replies

  13 years, 10 months ago

  By: Brandie Tarvin

• Odd Behavior of update query

  I executed this query: update table2 set id=(select max(id) from table1) where id=0. It indicates i…

  kapfundestanley

  2 replies

  13 years, 10 months ago

  By: Eugene Elutin

• Date range issue

  Hi Following is the code CREATE TABLE #ProductRate( [ProductID] [int] NOT NULL, [FromDate] [date…

  SQL006

  14 replies

  13 years, 10 months ago

  By: SQL006

• query to delete the records for 5 week older data

  Hi I have table which has to delete the 5 week older data.Please help out. I would appreciate your …

  Jay Pete

  5 replies

  13 years, 10 months ago

  By: Jay Pete