Welcome to EMC Consulting Blogs Sign in | Join | Help

Welcome to EMC Consulting Blogs

Browse by Tags

All Tags » SQL Server 2005 » SCOPE_IDENTITY

.NET
@@Identity
DML with output
OPEN XML
OPENXML
sp_xml_preparedocument
SQL Server
XML
Yukon

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. This can mean a huge performance improvement. Imagine having to call ...

Posted to Christian Wade's Blog (Weblog) by christian.wade on May 5, 2006

EMC2, EMC, and where information lives are registered trademarks of EMC Corporation.
All other trademarks used herein are the property of their respective owners.
© Copyright 2009 EMC Corporation. All rights reserved.

Powered by Community Server (Personal Edition), by Telligent Systems

Welcome to EMC Consulting Blogs

Browse by Tags

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