Advertisement
Guest User

Untitled

a guest
Oct 27th, 2016
60
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.45 KB | None | 0 0
  1. CREATE TRIGGER TriggerModify
  2. ON Costumers AFTER UPDATE AS
  3. BEGIN
  4. INSERT INTO Costumers_Update (
  5. CostumerID,
  6. ModifyDate,
  7. Name_New,
  8. Email_New,
  9. Name_Old,
  10. Email_Old,
  11. --etc
  12. )
  13. SELECT [Old].ID,
  14. GETDATE(),
  15. [New].Name,
  16. [New].Email,
  17. [Old].Name,
  18. [Old].Email,
  19. FROM inserted AS [New]
  20. CROSS JOIN
  21. deleted AS [Old]
  22. END
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement