Getting more done with OUTPUT

Use OUTPUT to perform an INSERT and a DELETE at the same time.

T-SQL - What is the output of the statement

Using the OUTPUT clause for practical applications

Learn how using the OUTPUT clause in SQL Server 2005 queries simplifies T-SQL code and returns results of rows changed by an INSERT, UPDATE or DELETE SQL command.