1. Learn
  2. /
  3. Courses
  4. /
  5. Building and Optimizing Triggers in SQL Server

Exercise

Tracking retired products

As shown in the example from the video, Fresh Fruit Delivery needs to keep track of any retired products in a dedicated history table (RetiredProducts).

You are asked to create a new trigger that fires when rows are removed from the Products table.

The information about the removed rows will be saved into the RetiredProducts table.

Instructions

100 XP
  • Create the TrackRetiredProducts trigger on the Products table.
  • Set the trigger to fire after rows are deleted from the table.