trigger Before update copy row data to archive table
What I want to have happen is before an update or delete occurs I want the row being affected to be copied out to an archive table. so I have a copy of what the data looked like before the update happened.
I'm not sure how to reference the data from the row being affected to insert it into an archive table of the same structure as the origingal.
DEAL and DEAL_ARCHIVE
so and update happens to any column of deal it copies the entire unaltered row affected over to DEAL_ARCHIVE then completes the update to DEAL.
Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!