Home Forums SQL Server 7,2000 T-SQL Triggers: determine name of updated column RE: Triggers: determine name of updated column
mccork
SSC-Insane
Points: 22288
More actions
July 23, 2003 at 1:14 am
#466518
If you use the value of the trigger's bitmask variable (function) COLUMNS_UPDATED(), then you should be able to analyse that bitstring, joining with syscolumns or information schema views to determine the column name.
Cheers,- Mark