Home Forums SQL Server 2005 Development How to avoid cursor for parent-child inserts RE: How to avoid cursor for parent-child inserts
WayneS
SSC Guru
Points: 95409
More actions
September 10, 2010 at 4:35 pm
#1219552
Check out the OUTPUT clause of the INSERT statement (this is what it's there for!).
(well, maybe other things to, but definitely this.)
WayneMicrosoft Certified Master: SQL Server 2008Author - SQL Server T-SQL Recipes