Compare inserted vs delete value

Last Post 24 Jan 2008 01:02 PM by timcronin. 0 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
timcronin
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
begin



It wants me to reference the tables in some type of where clause
You are not authorized to post a reply.

Acceptable Use Policy