CREATE TRIGGER T1OnUpdate ON T1 AFTER UPDATE AS INSERT INTO T2 (PK, OldValue, NewValue) SELECT i.PK, i.Value, d.Value FROM INSERTED i INNER JOIN DELETED d ON i.PK = d.PK
No comments:
Post a Comment