SQLServerCentral.com Content tagged Administration, T-SQL, SQL Server 2005, Advanced Queryinghttp://www.sqlservercentral.com/Content tagged Administration, T-SQL, SQL Server 2005, Advanced Querying posted on SQLServerCentral.comen-us360sjones@sqlservercentral.com (Steve Jones)Using the OUTPUT Clause to Capture Identity Values on Multi-Row InsertSQL Server 2005 introducted the OUTPUT clause which we can use to capture values from the inserted and deleted virtual tables.http://www.sqlservercentral.com/redirect/articles/2555/2006/08/25http://www.sqlservercentral.com/redirect/articles/2555/