Trigger on multiple columns
510477May 14 2008 — edited May 14 2008What is the syntax for an ON UPDATE trigger that only fires when certain columns in a table are updated. I am trying to include auditing features and record who changed a given record. I would prefer not to have to write a trigger for every column in the table, but I'm having a hard time finding an example of the proper syntax for a single trigger that can look at multiple (but not all) columns in a table. I don't want the trigger to fire if the audit columns get affected by other triggers.