Getting affected rows information from DML commands

Previous | Next

By webshiju
via dev-exchange.com
Submitted: Jul 08 2008 / 08:20

Getting affected rows information from DML commands - SQL Server

SQL server has a nice OUTPUT clause which can be used for retrieving the deleted/updated/inserted information from Data Manipulation Language (DML) commands. This article shows few examples on how to fetch the affected rows after executing INSERT,UPDATE or DELETE commands.

Vote up

Vote down