Disabling a trigger
Fresh Fruit Delivery needs to make some changes to a couple of rows in the Orders table.
Earlier they asked for a trigger to prevent unwanted changes to the Orders table, but now that trigger is stopping them from making the necessary modifications.
You are asked to help them with the situation by temporarily stopping that trigger from firing.
この演習はコースの一部です
Building and Optimizing Triggers in SQL Server
演習の手順
- Pause the trigger execution to allow the company to make the changes.
実践的なインタラクティブ演習
このサンプルコードを完成させて、この演習に挑戦してみましょう。
-- Pause the trigger execution
___ TRIGGER PreventOrdersUpdate
ON ___;