RE: Reduce Database RoundTrips Using XML

Michael-155044 — Tue, 29 Nov 2005 18:55:00 GMT

I use this a lot and it is a huge performance booster. Is there any reason that you shouldn't use the text or ntext data type as input to the stored procedure to avoide the 4000 byte limit? That would allow you 2,147,483,647 and 1,073,741,823 bytes respectively. I can't see passing that much data being practical, but you can blow out 4000 bytes quickly in an xml document. m I missing something here?

Syntax

sp_xml_preparedocument hdoc OUTPUT[, xmltext][, xpath_namespaces]

Arguments

hdoc

Is the handle to the newly created document. hdoc is an integer.

[xmltext]

Is the original XML document. The MSXML parser parses this XML document. xmltext is a text (char, nchar, varchar, nvarchar, text, or ntext) parameter. The default value is NULL, in which case an internal representation of an empty XML document is created.

[xpath_namespaces]

Specifies the namespace declarations that are used in row and column XPath expressions in OPENXML. The default value is <root xmlns:mp="urn:schemas-microsoft-com:xml-metaprop">.xpath_namespaces provides the namespace URIs for the prefixes used in the XPath expressions in OPENXML by means of a well-formed XML document. xpath_namespaces declares the prefix that must be used to refer to the namespace urn:schemas-microsoft-com:xml-metaprop, which provides meta data about the parsed XML elements. Although you can redefine the namespace prefix for the metaproperty namespace using this technique, this namespace is not lost. The prefix mp is still valid for urn:schemas-microsoft-com:xml-metaprop even if xpath_namespaces contains no such declaration. xpath_namespaces is a text (char, nchar, varchar, nvarchar, text, or ntext) parameter.

RE: Reduce Database RoundTrips Using XML

Josh Williams-153777 — Mon, 29 Nov 2004 15:16:00 GMT

Grate article. I find it very helpful

Thanks

Reduce Database RoundTrips Using XML

jwiner — Wed, 03 Nov 2004 16:42:00 GMT

Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/

SQLServerCentral / Discuss Content Posted by Jon Winer / Article Discussions / Article Discussions by Author / Reduce Database RoundTrips Using XML / Latest Posts

RE: Reduce Database RoundTrips Using XML

Arguments

RE: Reduce Database RoundTrips Using XML

Reduce Database RoundTrips Using XML