Home / Software / Tips and Tricks / How can I get information about the inserted or deleted rows from a table in SQL SERVER?

How can I get information about the inserted or deleted rows from a table in SQL SERVER?

Updated:  04/22/2011 14:04 PM
Author:  Shiju Mathews

Status:    Resolved.


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