Category Archives: SQL Output Clause

SQL Output Clause

SQL Server- Output clause

By | January 22, 2012

Output Clause:- The SQL SERVER 2005 gives us an Output Clause which gives us the information about each row affected by the Insert, Update , Delete and Merge statement. It is more useful than @@scope_Identity and @@Identity column since these global variables gives us the information about the last inserted identity column value, but the Output clause gives us… Read More »