How do you create a trigger to take care of the process of updating a table, to reflect a change downward in the quantity column?
1. The trigger needs to be an AFTER INSERT trigger on the above table so the trigger will not fire in case of exceptions.
2. The trigger must fire for each row that is inserted into the table.
3. The trigger will only involve the statement to lessen the quantity amount in the table for the example...movie ID.
July 16, 2008 3:48 PM
July 16, 2008 8:11 PM