Monday, July 24, 2017
 
 
     
Term: OUTPUT Clause
1 post(s)

SQL Server - Audit DML Changes without Triggers

By Saleem Hakani on 9/21/2014

You can now audit your changes using DML statements without even using TRIGGERS:

 

SQL Server supports an OUTPUT clause as a part of DML statements that can help you in tracking changes made during any DML operation. The OUTPUT clause can save the result set in a table or table variable.

The functionality is similar to what triggers had with INSERTED and DELETED tables which used to access the rows that have been modified during the DML operation.

OUTPUT Clause
Trigger
Minimize
SQL Article Tags
HOME   |   SQL ARTICLES   |   SCRIPTS   |   DISCUSSIONS   |   SQL TEAMS   |   JOBS   |   ABOUT US
Copyright [2014] by SQLCOMMUNITY.COM