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.

8th Mar 2017, 10:09 PM
Mayowa Arowolo
Mayowa Arowolo - avatar
1 Odpowiedź
+ 1
create trigger trigger_name on transactions.Orderdetails after insert as update Items.Itemdetails set QuantityInHand=... where...
9th Mar 2017, 5:32 AM
Álvaro