Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE TRIGGER AmountInsert ON Amount
- AFTER INSERT
- AS
- BEGIN
- UPDATE Product
- SET Amount_On_Stock =
- (SELECT Amount_On_Stock FROM Product
- WHERE ID_Product = 1) - 1
- WHERE ID_Product = 1
- END
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement