Advertisement
Guest User

Untitled

a guest
Apr 18th, 2014
42
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.29 KB | None | 0 0
  1. CREATE TRIGGER t AFTER INSERT ON x
  2. BEGIN {stmts} END
  3.  
  4. CREATE TRIGGER t ON x AFTER INSERT
  5. AS {stmts}
  6.  
  7. CREATE TRIGGER TR_PersonInserted INSERT ON Person
  8. BEGIN
  9. UPDATE Person
  10. SET ModifiedDate = DATETIME('NOW'), CreatedDate = DATETIME('NOW')
  11. WHERE PersonId = new.PersonId;
  12. END
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement