Advertisement
Guest User

Untitled

a guest
Jun 20th, 2019
94
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.21 KB | None | 0 0
  1. CREATE TRIGGER AmountInsert ON Amount
  2. AFTER INSERT
  3. AS
  4. BEGIN
  5. UPDATE Product
  6. SET Amount_On_Stock =
  7. (SELECT Amount_On_Stock FROM Product
  8. WHERE ID_Product = 1) - 1
  9. WHERE ID_Product = 1
  10. END
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement