Using the OUTPUT Clause to Capture Identity Values on Multi-Row Inserts

(graz) SQL Server 2005 introducted the OUTPUT clause which we can use to capture values from the inserted and deleted virtual tables. Previously this data was only available through triggers. We can use this in an INSERT … SELECT statement to capture all the inserted identity values. Previously th

Read More - Register for Free Membership