CREATE TRIGGER ShowUpdate on YourTable AFTER UPDATE AS BEGIN INSERT INTO NewDataTable SELECT id, name FROM inserted INSERT INTO OldDataTable SELECT id, name FROM Deleted END
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)