my first sql server trigger

This took me surprisingly long to figure out…

First create two tables for the test:

CREATE TABLE TriggerTestOne (
  Name varchar 50,
  AdditionalField varchar 50
)



CREATE TABLE TriggerTestTwo (
  Name varchar 50,
  LogEntry varchar 256,
  Action varchar 100
)


Then create the following trigger:

CREATE TRIGGER TestLog ON TriggerTestOne
FOR UPDATE
AS
if update(AdditionalField)
  insert into
    TriggerTestTwo (Action, Name, LogEntry)
    select 'remove', del.Name , del.AdditionalField from deleted del
  insert into
    TriggerTestTwo (Action, Name, LogEntry)
    select 'added', ins.Name , ins.AdditionalField from inserted ins


This will log all values changes in the AdditionalField column in TriggerTestOne into TriggerTestTwo.

The tricky part for me was trying to dig through the manuals to discover the delelted and inserted tables.