Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE TRIGGER TriggerModify
- ON Costumers AFTER UPDATE AS
- BEGIN
- INSERT INTO Costumers_Update (
- CostumerID,
- ModifyDate,
- Name_New,
- Email_New,
- Name_Old,
- Email_Old,
- --etc
- )
- SELECT [Old].ID,
- GETDATE(),
- [New].Name,
- [New].Email,
- [Old].Name,
- [Old].Email,
- FROM inserted AS [New]
- CROSS JOIN
- deleted AS [Old]
- END
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement