Msg#: 4238806 posted 2:24 am on Dec 5, 2010 (gmt 0)
I want to check the quantity of a good before we ship with a trigger that will fire a message that there isn't enough stuff if the quantity purchased is more than the inventory.
So here is a trigger on the inventory table.
for some reason, it won't recognize my table correctly.
In my stockqty is a valid field in inventory. reate trigger InventoryUpdateTriggerTRG on inventory for update as declare @myInventoryID as integer, @myQTY as integer; begin if update (stockqty) begin if inserted.stockqty<0 begin rollback transaction print ' not enough goodies to go around.' print ' We might want to re order' end end end