Table Trigger 1

[darkwing75]

Hi! I was wondering how would do create a trigger that would execute only if a particular column in a table has been updated? Thanks!

 

[dbomrrsm]

WIt depends on what you want the trigger to do.

Do you need to know that a row changed ?

Do you need to know which row changed ?

Do you need to see what the old and new values are from the row that changed.

DBomrrsm

 

[JohnDTampaBay]

Look up CREATE TRIGGER in BOL and check out the IF UPDATE (column) and IF (COLUMNS_UPDATED()) sections. Good luck!

--John
-----------------------------------
Behold! As a wild ass in the desert
go forth I to do my work.
--Gurnie Hallock (Dune)

 

[darkwing75]

Thanks for help, I wanted to know if a particular column in a row has been updated then run this trigger, I'll check BOL for those functions and try to figure this out thanks for the help!