I need to track changes / history of a user table. I have created a history table, and would like to put a trigger on the table to be tracked, inserting into the history table those columns which are modified each time. I can create the trigger with a number of 'IF UPDATE (column)' statements, but was wanting a more elegant way of doing this. Any suggestions?? As always, any help is greatly appreciated.
P.s. - this table should be modified one row at a time. There should not be any bulk inserts.
Thank You
Rollin Burr
Politicians and diapers have one thing in common. They should both be changed regularly, and for the same reason.