0
Ms Sql Trigger Syntax
Please i need help on how to create trigger for this; Table 1 transactions.Orderdetails Table 2 Items.Itemdetails When a record is inserted into the table 1, QuantityInHand in the table 2 should be updated automatically.
1 Odpowiedź
+ 1
create trigger trigger_name
on transactions.Orderdetails
after insert
as
update Items.Itemdetails set QuantityInHand=... where...