Home Forums SQL Server 2008 SQL Server 2008 - General SQL Trigger for multiple columns - Insert / update RE: SQL Trigger for multiple columns - Insert / update
TheSQLGuru
SSC Guru
Points: 134017
More actions
December 6, 2012 at 6:50 am
#1566143
This can be found in BOL:
1) IF UPDATE(b) OR UPDATE(c) ...
2) IF ( COLUMNS_UPDATED() & 2 = 2 )
Best,Kevin G. BolesSQL Server ConsultantSQL MVP 2007-2012TheSQLGuru on googles mail service