The TrackRetiredProducts trigger in action
Once you've created a trigger, it's always a good idea to see if it performs as expected.
The company's request for the trigger created earlier was based on a real need: they want to retire several products from their offering. This means you can check the trigger in action.
Bu egzersiz
Building and Optimizing Triggers in SQL Server
kursunun bir parçasıdırEgzersiz talimatları
Remove retired items from the Products table and check the output from the RetiredProducts table.
Uygulamalı interaktif egzersiz
Bu örnek kodu tamamlayarak bu egzersizi bitirin.
-- Remove the products that will be retired
DELETE FROM ___
WHERE Product IN ('Cloudberry', 'Guava', 'Nance', 'Yuzu');
-- Verify the output of the history table
SELECT * FROM ___;