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

Exercise

Table auditing using triggers

The company has decided to keep track of changes made to all the most important tables. One of those tables is Orders.

Any modification made to the content of Orders should be inserted into TablesAudit.

Instructions

100 XP
  • Create a new AFTER trigger on the Orders table.
  • Set the trigger to fire for INSERT, UPDATE, and DELETE statements.