Triggers What Changed?

[barski]

is there a way to determine on an update trigger what field was modified?

 

[HJB417]

I think youll need to use the COLUMNS_UPDATED function inside the trigger. Because Im a tsql noob, I cant provide sample code =(

...Assuming youre using mssql.

 

[PlausiblyDamp]

You can always use the UPDATE keyword

IF UPDATE(<fieldname>)
BEGIN
    --handle updated field here
END

Also http://www.databasejournal.com/features/mssql/article.php/1479821 contains a decent article on COLUMNS_UPDATED in case that is how you decide to handle it.

 

[barski]

thanks for the help.