Modifying a trigger's definition
A member of the Sales team has noticed that one of the triggers attached to the Discounts table is showing a message with the word "allowed" missing.
Bu egzersiz
Building and Optimizing Triggers in SQL Server
kursunun bir parçasıdırEgzersiz talimatları
- Modify the trigger definition and fix the typo without dropping and recreating the trigger.
- Add the missing word to the
PRINTstatement.
Uygulamalı interaktif egzersiz
Bu örnek kodu tamamlayarak bu egzersizi bitirin.
-- Fix the typo in the trigger message
___ TRIGGER PreventDiscountsDelete
ON ___
INSTEAD OF DELETE
AS
PRINT 'You are not ___ to remove data from the Discounts table.';