Practicing with AFTER triggers
Fresh Fruit Delivery company is happy with your services, and they've decided to keep working with you.
You have been given the task to create new triggers on some tables, with the following requirements:
Keep track of canceled orders (rows deleted from the
Orderstable). Their details will be kept in the tableCanceledOrdersupon removal.Keep track of discount changes in the table
Discounts. Both the old and the new values will be copied to theDiscountsHistorytable.Send an email to the Sales team via the
SendEmailtoSalesstored procedure when a new order is placed.
この演習はコースの一部です
Building and Optimizing Triggers in SQL Server
実践的なインタラクティブ演習
このサンプルコードを完成させて、この演習に挑戦してみましょう。
-- Create a new trigger for canceled orders
CREATE TRIGGER KeepCanceledOrders
ON ___
AFTER ___
AS
INSERT INTO ___
SELECT * FROM deleted;