Sams Teach Yourself SQL in 21 Days, Fourth Edition

CREATE TRIGGER

						create trigger trigger_name
  on table_name
  for {insert, update, delete}
  as SQL_Statements

The CREATE TRIGGER statement creates a trigger object in the database that will execute its SQL statements when its corresponding table is modified through an INSERT, UPDATE, or DELETE. Triggers can also call stored procedures to execute complex tasks.