Triggers What Changed?

[barski]

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

[HJB417]

I think you'll need to use the COLUMNS_UPDATED function inside the trigger. Because I'm a tsql noob, I can't provide sample code =(

 

...Assuming you're using mssql.

[PlausiblyDamp]

You can always use the UPDATE keyword

IF UPDATE()
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.