T-SQL

• Topics

  Started by

  Posts

  Last post

• Trigger help

  Hello every one. I created this trigger which works fine for it's purpose. The problem is that ther…

  Raulie

  1 replies

  22 years ago

  By: Raulie

• last 4 months data

  Hi friends I've 2 tables Task and Assignments .task is PK table assignment is fk table example dat…

  sqlpro

  4 replies

  22 years ago

  By: sqlpro

• Trimmimg off trailing tab charater

  In a procedure where I'm building a string from a select. How can I remove the trailing Tab before …

  demicoq

  5 replies

  22 years ago

  By: Peter P

• how to perform a cascading delete operation

  Hi, there I want to delete all records from one table and any dependent records, recursively. But t…

  billz

  4 replies

  22 years ago

  By: billz

• group by and sort by datepart(month)

  I have a table that contains project information, with one column called EndDate of DateTime data t…

  mvander

  4 replies

  22 years ago

  By: Caine Schneider

• Stored Procedure Changes

  Hi, I need to alter like 100 stored procedurs (changing the table names), is there any way to chang…

  rs

  3 replies

  22 years ago

  By: rs

• Manage sql server messages. Is it possible?

  I have a stored procedure with an action (insert, update etc.). I would like to modify the message …

  Stefan Ardeleanu

  2 replies

  22 years ago

  By: Stefan Ardeleanu

• Raiserror. Is it posible to handle the message before the error is it raised?

  I believe not but who knows? I would like to handle the messages to add others informatio…

  Stefan Ardeleanu

  2 replies

  22 years ago

  By: Stefan Ardeleanu

• ODBCBCP driver version conflict

  Hi All, While I am executing BCP command, I am getting following message in output file My BCP Comm…

  shreedhar

  3 replies

  22 years ago

  By: shreedhar

• Building a series of strings while in a cursor or while loop

  Well, I've hit my head on the wall enough times today so I think I'll present my issue to my friend…

  demicoq

  3 replies

  22 years ago

  By: gljjr

• Check for existing column of a table

  How can I check to see if a column exists in a table by using the MS system store procedures? …

  Min Chen-141523

  3 replies

  22 years ago

  By: bdohmen

• Crosstab aggregate error, A Stumper!

  I'm scratching my head on this one...What's wrong?  Here's the SQL:     SELECT…

  GregLyon

  6 replies

  22 years ago

  By: GregLyon

• How to put contents of another strored proc. into a cursor or a table?

  Hi all! I'm building a stored proc. that returns a table of data into another stored proc. in that …

  LoorD

  1 replies

  22 years ago

  By: Stefan Ardeleanu

• Attaching sql server2000 database to msde

  I have been trying to attach a database i earlier detached from sql server 2000 to msde but to no a…

  Bola Idowu

  7 replies

  22 years ago

  By: Bola Idowu

• date range query

  HI FRIENDS i've data like following supportid,fk_clientid,cl_name,fk_staffid,Staffname,fk_catid,Cat…

  sqlpro

  6 replies

  22 years ago

  By: sqlpro