OUTPUTing Data from the Just-Inserted, Updated, or Deleted Row(s)

Scott Mitchell discusses a little gem he discovered, which is the use of OUTPUT clause in INSERT, UPDATE, DELETE and MERGE (2008) DML statement to get the effect of in-place triggers and more.