I have just written my first trigger and I have few
questions. The trigger is to adjust quantities after an
order has been made.
1. "from Inserted" - this is reading the new inserted
2. "from deleted" - this is reading the buffer for the one
record that has just been deleted?
3. "Set InvtID = (Select InvtID from Inserted)"
Set QtySold = QtySold + 1, QtyonHand = QtyonHand - 1
Where Inventory.InvtID = InvtID"
4. Am I on the right track.
5. Is there a nice simple how to page on triggers ...