Ms Sql Trigger Syntax | Sololearn: Learn to code for FREE!
Nouvelle formation ! Tous les codeurs devraient apprendre l'IA générative !
Essayez une leçon gratuite
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 Réponse
+ 1
create trigger trigger_name on transactions.Orderdetails after insert as update Items.Itemdetails set QuantityInHand=... where...
9th Mar 2017, 5:32 AM
Álvaro