Home Forums Article Discussions Article Discussions by Author Discuss content posted by BINU PRASAD.M Find List of Columns Updated inside Trigger RE: Find List of Columns Updated inside Trigger
facemann
Right there with Babe
Points: 797
More actions
February 10, 2014 at 12:39 pm
#1687663
I agree Matt. This is what I use in my triggers to see if a change has actually occurred.
IF EXISTS (SELECT *
FROM
INSERTED I JOIN DELETED D ON I.Key = D.Key
WHERE
I.Col <> D.Col)