Using OUTPUT clauses to check data changes in a SQL script

A colleague recently showed me the OUTPUT clause in SQL Server, which I wasn't familiar with. It allows you to view the data which has been changed by a query as part of that query. For example, to view the data inserted by an INSERT statement, you c...