Guest User

Untitled

a guest
Jun 24th, 2018
121
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.35 KB | None | 0 0
  1. CREATE TRIGGER test ON Articles
  2. FOR INSERT, UPDATE
  3. AS
  4. IF UPDATE(Description)
  5. UPDATE Articles SET LastActivityDate = GETUTCDATE()
  6.  
  7. CREATE TRIGGER test ON Articles
  8. FOR INSERT, UPDATE
  9. AS
  10. IF UPDATE(Description)
  11. UPDATE a
  12. SET a.LastActivityDate = GETUTCDATE()
  13. from Articles a
  14. inner join inserted i
  15. on a.SomeIDField = i.SomeIDField
Add Comment
Please, Sign In to add comment