Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE TRIGGER test ON Articles
- FOR INSERT, UPDATE
- AS
- IF UPDATE(Description)
- UPDATE Articles SET LastActivityDate = GETUTCDATE()
- CREATE TRIGGER test ON Articles
- FOR INSERT, UPDATE
- AS
- IF UPDATE(Description)
- UPDATE a
- SET a.LastActivityDate = GETUTCDATE()
- from Articles a
- inner join inserted i
- on a.SomeIDField = i.SomeIDField
Add Comment
Please, Sign In to add comment