Home Forums SQL Server 7,2000 T-SQL Triggers: determine name of updated column RE: Triggers: determine name of updated column

  • 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