Just Learned - UPDATE with OUTPUT clause can be used for auditing Old values and New Values

Getting Started with Adobe After Effects - Part 6: Motion Blur


	Just Learned

A collection of quick technology learning tips from what people around you learn every day


	Submit a tip


	Subscribe..

Home · Most Liked · Most Learned · Most Discussed · Silver Rated · Sections

UPDATE with OUTPUT clause can be used for auditing Old values and New Values

Aug 4 2011 3:54AM by Adam Tokarski

OUTPUT clause can return in parallel way both INSERTED and DELETED rows. It is useful to logging in archive original and new values.

...
OUTPUT DELETED.value [oldValue], INSERTED.value [newValue]

2 Comments

You can read more here, http://beyondrelational.com/blogs/paresh/archive/2011/06/20/output-clause-with-insert-update-and-delete-statements-in-sql-server-2005.aspx

commented on Aug 4 2011 4:54AM

Paresh Prajapati

6 · 22% · 7054

You can read about the I/O, performance improvements offered by the OUTPUT clause and also about it's limitations from my post: http://beyondrelational.com/blogs/nakul/archive/2011/03/21/output-clause-underappreciated-features-of-microsoft-sql-server.aspx

commented on Aug 5 2011 9:28AM

Nakul Vachhrajani

4 · 33% · 10575

Your Comment

Sign Up or Login to post a comment.

"UPDATE with OUTPUT clause can be used for auditing Old values and New Values" rated 5 out of 5 by 6 readers