Identify columns changed

• vmon

  SSChasing Mays

  Points: 624

  More actions

  March 15, 2010 at 1:04 pm

  #216670

  I have code on an update trigger that sends an email when a record is changed. Is there an easy way to identify which column(s) would have been changed?

  ANy help would be appreciated.

  Thanks,

  vmon

• Lamprey13

  SSCertifiable

  Points: 6210

  More actions

  March 15, 2010 at 2:43 pm

  #1134074

  There are several ways and I'm not sure any are all that great. Take a look in BOL for COLUMNS_UPDATED. That is one of the ways to determine which columns have changed.

• Paul White

  SSC Guru

  Points: 150467

  More actions

  March 16, 2010 at 7:31 am

  #1134428

  You can use IF UPDATE or COLUMNS_UPDATED, see Programming DML Triggers for details and examples.

  Paul White
  SQLPerformance.com
  SQLkiwi blog
  @SQL_Kiwi