Friday, March 30, 2012

Saving updated row

Is there a way to save a record(s) prior to modifying values in it via trigger? If not, what options do I have to maintain something like a snapshot of the record(s) besides backups?
BTW, I use SQL 7.
ThanksRefer to Using the inserted and deleted Tables under books online.

No comments:

Post a Comment