Welcome to EMC Consulting Blogs

May 2006 - Posts

• Nice use of DML with output: update a collection in 1 db round trip

  I’ve seen a few Conchango developers in the past use sp_xml_preparedocument and OPENXML to commit a serialized collection object to the database. We can do this in SQL Server 2000 and it avoids a round trip to the database for each collection member. Read More... Posted 05 May 2006 13:25 by christian.wade | 1 Comments Filed under: SQL Server 2005, Yukon, SQL Server, OPENXML, OPEN XML, sp_xml_preparedocument, .NET, XML, DML with output, @@Identity, SCOPE_IDENTITY