Category: SQL Server
view more software Tips and Tricks
Updated: 04/22/2011 14:04 PM
Author: Shiju Mathews
SQL Server 2005 introduced OUTPUT Clause (Transact-SQL) that returns information from, or expressions based on, each row affected by an INSERT, UPDATE, or DELETE statement. These results can be returned to the processing application for use in such things as confirmation messages, archiving, and other such application requirements. Alternatively, results can be inserted into a table, table variable or temporary table.
This can be use conjunction with DELETE ,INSERT ,UPDATE clause.
For more information visit technet.microsoft.com