Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE TRIGGER INSERTEDAndDELETEDTableExample
- ON transcriptTable
- FOR UPDATE
- AS
- BEGIN
- --to get the old value (insert statement may vary depend on your need and table)
- insert into trancriptTable_log (column_1) SELECT <your_column_name> FROM DELETED
- --to get the new value
- insert into trancriptTable_log values (column_2) SELECT <your_column_name> FROM INSERTED
- END
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement