Get startedGet started for free

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.

This exercise is part of the course

Building and Optimizing Triggers in SQL Server

View Course

Exercise instructions

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

Hands-on interactive exercise

Have a go at this exercise by completing this sample code.

-- Create the trigger
CREATE ___ TrackRetiredProducts
ON ___
___ DELETE
AS
	INSERT INTO RetiredProducts (Product, Measure)
	SELECT Product, Measure
	FROM deleted;
Edit and Run Code