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

Exercise

Preventing changes to Products

The Fresh Fruit Delivery company doesn't want regular users to be able to change product information or the actual stock.

Instructions

100 XP
  • Create a new trigger, PreventProductChanges, that prevents any updates to the Products table.