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

Exercise

Creating a trigger to keep track of data changes

The Fresh Fruit Delivery company needs to keep track of any new items added to the Products table. You can do this by using a trigger.

The new trigger will store the name, price, and first introduced date for new items into a ProductsHistory table.

Instructions

100 XP
  • Create the ProductsNewItems trigger on the Products table.
  • Set the trigger to fire when data is inserted into the table.