Thank you!
This is my Trigger: ALTER TRIGGER [dbo].[trig_onUpdateLocation] ON [dbo].[Location] FOR UPDATE AS declare @ID varchar(20) select @ID = (select...
Great! Thank you! What about the syntax is obsolete and how has it been replaced? Thanks again!
I'd like to return a record set that contains a calculated field in addition to all of the fields in a particular table. This is the script that...
Thank you all for your help! The solution posted by vbkenya will work for my application. I don't anticipate running into the scenarios listed by...
I have a table that I#%92m using an identity column in. This column (ItemID) is the second column of the key (with the first being "JobID"). I#%92d...
Separate names with a comma.
