Development

• Topics

  Started by

  Posts

  Last post

• Documenting Database Code

  Was wondering if anyone had any recommended programs or scripts for documenting database code. Spe…

  jvanderberg

  8 replies

  15 years ago

  By: jvanderberg

• Returning Row Counts From Procedure?

  I have a procedure that selects records from one table to another, depending on the error flag, Int…

  Stamey

  2 replies

  15 years ago

  By: Stamey

• Need a Query to sumup the values according to Department structure

  Hai, I want to sum up the child department values and display in the parent record Below is the Tab…

  mohanaraj

  1 replies

  15 years ago

  By: Dave Ballantyne

• Replacing substring with a substring

  I'm attempting to use the following query to update the substring %/themes/old/% with '%/themes/new…

  rabisco

  7 replies

  15 years ago

  By: Jeff Moden

• VARCHAR(MAX) and limitations

  Alright, the question came up with what happens when the text string coming in is too big for the '…

  Evil Kraig F

  4 replies

  15 years ago

  By: Jeff Moden

• Delete Query

  Hi friends need Delete Query Delete from StoreGroupMember Where d in (select * from StoreGroupMemb…

  JakDBA

  2 replies

  15 years ago

  By: Derrick Smith

• Lookign for the Name of requestor's machine

  Hi, I am building a driver table for an automation project. I can use SUSER_SNAME() to grab the use…

  Pieter-423357

  2 replies

  15 years ago

  By: Pieter-423357

• Calling a UDF

  [font="Tahoma"]Hi all I have a table with the some Statistical data... I am working on a SSIS packa…

  vani_r14

  13 replies

  15 years ago

  By: vani_r14

• Needa Query to filter the matching records

  Need a Query to filter the matching records from table. Having 2 tables. Table A Having 100 record…

  sugan

  5 replies

  15 years ago

  By: shanu.hoosen

• Sp_send_dbmail

  Hi EXEC msdb.dbo.sp_send_dbmail @profile_name = 'SqlNotification' , @recipients = 'bkumar@ab…

  Bhuvnesh

  5 replies

  15 years ago

  By: Bhuvnesh

• How to avoid cursor for parent-child inserts

  I've googled this and found plenty of preaching on avoiding cursors in small-scale applications, bu…

  Jason Akin

  7 replies

  15 years ago

  By: WayneS

• Columns_Updated() in update trigger reverses the bitmask?

  I have some significant strangeness going on with columns_updated() in an update trigger. It appea…

  Evil Kraig F

  13 replies

  15 years ago

  By: Jeff Moden

• comparing two table structure

  Is there a script which will compare the structure of two tables. one table resides in sql 2005 and…

  balbirsinghsodhi

  5 replies

  15 years ago

  By: ksullivan

• arithmetic overflow error

  aa

  ekknaveen

  2 replies

  15 years ago

  By: Madhivanan-208264

• How to disable a default constraint in Sql Server 2005?

  Hi, I'm trying to disable a defualt constraint on one of my table.I know that we can drop and recre…

  pkposani

  2 replies

  15 years ago

  By: Lowell