SQL TRIGGER: Add a trigger to your check table (or equivalent) so that whenever a new sale of a menu item occurs (i.e. a new INSERT to Check Detail), automatically deduct the quantity from the quantity on hand of that item's inventory.

Please show an example of a trigger statement that goes with the question above.

You may use your own tables/values but please explain what the tables mean.

Answer rating: 100% (QA)

sql Create CheckDetail table for sales transactions CREATE TABLE CheckDetail SaleID INT PRIMARY KEY ... View the full answer