PreventOrdersUpdate in action
Let's see what the newly created trigger does when you try to update some rows in the Orders table.
Run the following script to change the order quantity to 700 for order number 425:
UPDATE Orders
SET Quantity = 700
WHERE OrderID = 425;
What happens when you run the code?
Latihan ini adalah bagian dari kursus
Building and Optimizing Triggers in SQL Server
Latihan interaktif praktis
Ubah teori menjadi tindakan dengan salah satu latihan interaktif kami.
Mulai berolahraga