Compare inserted vs delete value

Last Post 24 Jan 2008 01:02 PM by timcronin. 0 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages
New Member
New Member

24 Jan 2008 01:02 PM
I have a trigger on a table for update where the update may be a record at a time or a mass update. I need to check if one of the columns has changed (not updated). I can't use variables to trap values because with a mass update I leaned my lesson the it only updated the first record. The question is how can I compare it. I tried below but this errors out

if select ltrim(rtrim(inserted.df_sitename)) from inserted <> deleted.df_sitename

It wants me to reference the tables in some type of where clause

Acceptable Use Policy