T-SQL (SS2K5)

• Topics

  Started by

  Posts

  Last post

• Fetching records optimally

  CREATE TABLE tblTestId ( id int, NAME VARCHAR(10) ); INSERT INTO tblTestId SELECT 1,'Empa' UNION AL…

  thbaig

  5 replies

  12 years, 9 months ago

  By: Sean Lange

• Transaction Log Growing Despite Simple Recovery

  I have a data warehouse database which is set to simple recovery. The transaction log was original…

  jvanderberg

  27 replies

  12 years, 9 months ago

  By: Gail Shaw

• sp_send_dbmail fails within a trigger

  I'm trying to write a trigger that will inform me via an email using sp_send_dbmail when a certain …

  Griffster

  9 replies

  12 years, 9 months ago

  By: simon.letts

• Best approch to finding/fixing miss-spelled names.

  I have a column in a table that has user names, user can appear in this table multiple time, but as…

  ps_vbdev

  3 replies

  12 years, 9 months ago

  By: Orlando Colamatteo

• What happenif we run sql statement

  Hi, What happened if we run select statement i.e Select * from TableName; When we execute the above…

  suresh0534

  1 replies

  12 years, 9 months ago

  By: Gail Shaw

• XML Parsing - Unable to switch the encoding - Error

  Hi, I am getting the following error when I try to parse XML. declare @xml xml set @xml = '[Code]&l…

  Aparna-1

  3 replies

  12 years, 9 months ago

  By: TangoVictor

• CASE in WHERE clause

  I am converting embedded SQL (in Java code) to a stored procedure. They are building SQL WHERE clau…

  RVO

  16 replies

  12 years, 9 months ago

  By: Eugene Elutin

• SQL QUERY

  sql query to find a particular word in a field of table eg: in a field, gunapandian is a name, if i…

  gunapandian.mca07

  3 replies

  12 years, 9 months ago

  By: mayank.bhargava16

• For every date in one table find the financial period in another table - struggling to find an answer

  I have searched the web and struggling to find the right answer to this. I think it is simple but …

  susan.swaffield

  4 replies

  12 years, 9 months ago

  By: susan.swaffield

• date column behaving strangely

  hi, i have a column that's treating dates in an odd way. select filldate, datediff(dd, filldate, g…

  sqldriver

  3 replies

  12 years, 9 months ago

  By: sqldriver

• sql2005

  hello, how i can verify the last date modify of a table or a stored procedure. thank you for your h…

  eboucicaut

  3 replies

  12 years, 9 months ago

  By: Adi Cohn-120898

• Stored Procedure runs slower than SQL Query Why??

  Hello - I created a Store Procedure to have Table A sync with Table B by doing an insert of the da…

  david.ostrander

  1 replies

  12 years, 9 months ago

  By: Eugene Elutin

• Looping without cursor not updating properly

  I got asked to not use a cursor for a loop that I'm working on so I grabbed the code here: http://w…

  Siobhan Perricone

  38 replies

  12 years, 9 months ago

  By: Siobhan Perricone

• MULTIPLE INSERT IN A DESIRED SEQUENCE

  I HAVE A TABLE WITH THREE FIELD COMCOD nchar(4) DUPLICATE ALLOWED FOREIGN KEY, ACTCODE nvarchar(6) …

  Neel 7777

  3 replies

  12 years, 9 months ago

  By: Eugene Elutin

• UPDATE PART OF DATA

  TABLE IS LIKE COMCOD ACTCODE ACTDESC 3306 180001 ADVANCE TO ST…

  Neel 7777

  2 replies

  12 years, 9 months ago

  By: Cadavre