Mark Wilkinson shows off some fun stuff you can do with the OUTPUT clause:
A common command in the Linux world is the
teecommand. Whatteeallows you to do is pipe the output of a command to a file as well as the console. This same functionality can be implemented using multipleOUTPUTclauses in a T-SQL statement. In this example we are going to update a few hundred records. When the update statement is run, not only will it update the MyGuid table but it will update a log table and also return the result of the update. This is accomplished by using twoOUTPUTclauses.
Check it out. I don’t use OUTPUT that often, but it can be quite useful when in a pinch or if you want to prevent scanning a table twice.