Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE TRIGGER t AFTER INSERT ON x
- BEGIN {stmts} END
- CREATE TRIGGER t ON x AFTER INSERT
- AS {stmts}
- CREATE TRIGGER TR_PersonInserted INSERT ON Person
- BEGIN
- UPDATE Person
- SET ModifiedDate = DATETIME('NOW'), CreatedDate = DATETIME('NOW')
- WHERE PersonId = new.PersonId;
- END
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement