Xml SQL Server Reference Documentation

Xml

Current Version: 11.6.0

Chilkat.Xml

Load, navigate, search, edit, transform, and save in-memory XML trees.

Chilkat.Xml is the primary Chilkat class for in-memory XML tree manipulation. It supports loading and saving XML, navigating between elements, reading and writing text content, managing attributes, working with namespaces, adding and removing subtrees, searching by tag, content, or attribute, sorting child records, scrubbing XML, handling CDATA and XML declarations, storing binary data as Base64, and optionally compressing or encrypting element content.

Load and save XML

Load XML from strings, files, byte data, or other Chilkat objects, then save or emit formatted XML when processing is complete.

Navigate XML trees

Move through parent, child, sibling, and selected elements while working directly with the XML document structure.

Edit elements and attributes

Add, update, remove, or rename elements; set text content; and read, add, modify, or delete attributes.

Search and select

Locate elements by tag name, content, path, attribute value, or custom search patterns.

Namespaces and structure

Work with namespace-aware XML, declarations, CDATA, child ordering, sorting, and subtree insertion or removal.

Binary and protected content

Store binary data as Base64 and optionally compress or encrypt element content when XML carries encoded payloads.

Important usage distinction: Some methods return a new Xml object reference for the selected element, while methods ending in 2 update the caller's internal reference to point to a different element. This distinction is central when navigating and editing XML trees because it determines whether the current object stays where it is or moves to another element.
Common pattern: Load or create the XML document, navigate to the element of interest, read or modify content and attributes, add or remove child elements as needed, then save the updated XML. Use Chilkat.Xml for tree-oriented XML manipulation, and use Chilkat.XmlDSig, Chilkat.XmlDSigGen, or related classes when the task is XML digital signing or signature verification.

Object Creation

DECLARE @hr int
DECLARE @xml int
EXEC @hr = sp_OACreate 'Chilkat.Xml', @xml OUT
IF @hr <> 0
BEGIN
    PRINT 'Failed to create ActiveX component'
    RETURN
END

-- ... use @xml ...

EXEC @hr = sp_OADestroy @xml

T-SQL uses the Chilkat ActiveX through the OLE Automation stored procedures. They must be enabled once on the server (EXEC sp_configure 'Ole Automation Procedures', 1; RECONFIGURE;), and the Chilkat ActiveX registered must match the bitness of the SQL Server instance (64-bit for a 64-bit SQL Server). To bind to a specific major version of Chilkat, append the major version number to the ProgID, such as sp_OACreate 'Chilkat.Xml.11' for Chilkat v11.*.*.

sp_OACreate returns an object token (an int) that is passed as the first argument of every sp_OAMethod, sp_OAGetProperty and sp_OASetProperty call, and released with sp_OADestroy. Objects returned by methods (such as an HttpResponse or JsonObject) are also tokens received through an int OUT parameter; they must likewise be destroyed, and the OUT parameter is NULL when the method fails to return an object. Objects passed as arguments are passed by their token. When an OLE Automation procedure itself fails (non-zero @hr), sp_OAGetErrorInfo describes the error.

Data types: strings are nvarchar(4000); integers, booleans (1 or 0) and object tokens are int; dates are datetime. In the signatures on this page, @success, @iResult, @sResult and the like are the OUT variables receiving a method's return value, @iValue / @sValue receive or supply a property value, and the remaining @ variables are the method's arguments in order.

A string returned through an OUT parameter is limited to 4000 characters. For longer values, retrieve the result as a result set into a table variable instead of an OUT parameter, for example DECLARE @tmp TABLE (outputLine ntext) followed by INSERT INTO @tmp EXEC sp_OAGetProperty @xml, 'LastErrorText'. See string length limitations for strings returned by sp_OAMethod calls.

Methods that pass or return raw byte arrays are not shown on this page, because varbinary(max) values cannot be exchanged through sp_OAMethod (see varbinary(max) limitation). Use the BinData-based alternatives (methods ending in Bd) or the base64 / hex string-encoded variants instead. Binary properties (such as LastBinaryResult) can be retrieved as a result set into a table variable, as shown in their signatures. Asynchronous (*Async) methods and event callbacks are not available from SQL Server.

Properties

Cdata
EXEC sp_OAGetProperty @xml, 'Cdata', @iValue OUT
EXEC sp_OASetProperty @xml, 'Cdata', @iValue

Controls how this element's text content is emitted. When set to 1, the element content is written inside a CDATA section instead of being emitted as ordinary character data with XML escaping.

CDATA and escaping: CDATA is useful when text contains many characters such as < or &. It does not change the logical text value of the element; it only changes how that text is represented in the serialized XML.

More Information and Examples
top
Content
EXEC sp_OAGetProperty @xml, 'Content', @sValue OUT
EXEC sp_OASetProperty @xml, 'Content', @sValue

Gets or sets the text content stored directly on this XML element. Child elements are not included in this value.

For example, both of the following elements have This is the content as their Content:

<tag1>This is the content</tag1>

<tag2><child1>abc</child1><child2>abc</child2>This is the content</tag2>
Content vs. children: Chilkat stores an element's direct text content separately from its child elements. Use the child-navigation methods when you need the nested elements themselves.

top
ContentInt
EXEC sp_OAGetProperty @xml, 'ContentInt', @iValue OUT
EXEC sp_OASetProperty @xml, 'ContentInt', @iValue

Gets or sets this element's content as a 32-bit integer. Setting the property converts the integer to its decimal text representation; getting the property interprets the element's text content as an integer.

Numeric content: Use Content when the value may exceed the range of a 32-bit integer or when the exact lexical representation must be preserved.

top
DebugLogFilePath
EXEC sp_OAGetProperty @xml, 'DebugLogFilePath', @sValue OUT
EXEC sp_OASetProperty @xml, 'DebugLogFilePath', @sValue

If set to a file path, this property logs the LastErrorText of each Chilkat method or property call to the specified file. This logging helps identify the context and history of Chilkat calls leading up to any crash or hang, aiding in debugging.

Enabling the VerboseLogging property provides more detailed information. This property is mainly used for debugging rare instances where a Chilkat method call causes a hang or crash, which should generally not happen.

Possible causes of hangs include:

  • A timeout property set to 0, indicating an infinite timeout.
  • A hang occurring within an event callback in the application code.
  • An internal bug in the Chilkat code causing the hang.

More Information and Examples
top
DocType
EXEC sp_OAGetProperty @xml, 'DocType', @sValue OUT
EXEC sp_OASetProperty @xml, 'DocType', @sValue

Gets or sets the document type declaration associated with the XML document.

The value represents the document-level DOCTYPE declaration, for example <!DOCTYPE note SYSTEM "note.dtd">.

Document-level setting: Although this property may be accessed from any element reference in the tree, the DOCTYPE belongs to the XML document as a whole rather than to an individual element.

More Information and Examples
top
EmitBom
EXEC sp_OAGetProperty @xml, 'EmitBom', @iValue OUT
EXEC sp_OASetProperty @xml, 'EmitBom', @iValue
Introduced in version 9.5.0.44

Controls whether a byte order mark (BOM, also called a preamble) is written when XML is saved to a file. The default is 0.

This setting is relevant to encodings for which a BOM can be emitted, such as UTF-8 and UTF-16. It does not affect XML returned as a language string by methods such as GetXml.

top
EmitCompact
EXEC sp_OAGetProperty @xml, 'EmitCompact', @iValue OUT
EXEC sp_OASetProperty @xml, 'EmitCompact', @iValue
Introduced in version 9.5.0.64

Controls whether XML emitted by GetXml and GetXmlSb is compact. When 1, unnecessary formatting whitespace and line breaks are omitted. The default is 0 for backward compatibility.

Formatting only: Compact output changes presentation, not the XML tree or its element content.

More Information and Examples
top
EmitXmlDecl
EXEC sp_OAGetProperty @xml, 'EmitXmlDecl', @iValue OUT
EXEC sp_OASetProperty @xml, 'EmitXmlDecl', @iValue

Controls whether the XML declaration is included when XML is emitted. The default is 1. When set to 0, output methods such as GetXml and SaveXml omit the declaration.

An XML declaration is the leading construct such as <?xml version="1.0" encoding="utf-8"?>.

top
Encoding
EXEC sp_OAGetProperty @xml, 'Encoding', @sValue OUT
EXEC sp_OASetProperty @xml, 'Encoding', @sValue

Gets or sets the encoding value used in the XML declaration. The default is utf-8. This is a document-level setting and may be accessed from any element in the tree.

When XML is loaded, Chilkat sets this property from the encoding declared by the input XML when one is present. If no encoding is declared, the property is reset to utf-8.

Important: Changing Encoding changes the declared/output encoding used when XML is serialized; it does not reinterpret or transcode the already-stored Unicode text inside the in-memory tree.

top
I
EXEC sp_OAGetProperty @xml, 'I', @iValue OUT
EXEC sp_OASetProperty @xml, 'I', @iValue
Introduced in version 9.5.0.64

Provides a substitution value for [i] in Chilkat tag paths and ChilkatPath expressions. When a path contains [i], the current value of this property is substituted for I.

Loop-friendly paths: The I, J, and K properties make it convenient to reuse a path expression inside nested loops without constructing a new path string for every index.

top
IsBase64
EXEC sp_OAGetProperty @xml, 'IsBase64', @iValue OUT
Introduced in version 9.5.0.76

Returns 1 if this element's content consists only of characters allowed in standard Base64 text, with whitespace ignored. Standard Base64 uses A-Z, a-z, 0-9, +, /, and optional trailing = padding.

Syntax check, not semantic validation: A value can contain only Base64 characters and still not represent the data your application expects. This property is useful as a quick content-format test.

top
J
EXEC sp_OAGetProperty @xml, 'J', @iValue OUT
EXEC sp_OASetProperty @xml, 'J', @iValue
Introduced in version 9.5.0.64

Provides a substitution value for [j] in Chilkat tag paths and ChilkatPath expressions. When a path contains [j], the current value of this property is substituted for J.

Loop-friendly paths: The I, J, and K properties make it convenient to reuse a path expression inside nested loops without constructing a new path string for every index.

More Information and Examples
top
K
EXEC sp_OAGetProperty @xml, 'K', @iValue OUT
EXEC sp_OASetProperty @xml, 'K', @iValue
Introduced in version 9.5.0.64

Provides a substitution value for [k] in Chilkat tag paths and ChilkatPath expressions. When a path contains [k], the current value of this property is substituted for K.

Loop-friendly paths: The I, J, and K properties make it convenient to reuse a path expression inside nested loops without constructing a new path string for every index.

top
LastBinaryResult
INSERT INTO @tmp EXEC sp_OAGetProperty @xml, 'LastBinaryResult'

This property is mainly used in SQL Server stored procedures to retrieve binary data from the last method call that returned binary data. It is only accessible if Chilkat.Global.KeepBinaryResult is set to 1. This feature allows for the retrieval of large varbinary results in an SQL Server environment, which has restrictions on returning large data via method calls, though temp tables can handle binary properties.

top
LastErrorHtml
EXEC sp_OAGetProperty @xml, 'LastErrorHtml', @sValue OUT

Provides HTML-formatted information about the last called method or property. If a method call fails or behaves unexpectedly, check this property for details. Note that information is available regardless of the method call's success.

top
LastErrorText
EXEC sp_OAGetProperty @xml, 'LastErrorText', @sValue OUT

Provides plain text information about the last called method or property. If a method call fails or behaves unexpectedly, check this property for details. Note that information is available regardless of the method call's success.

top
LastErrorXml
EXEC sp_OAGetProperty @xml, 'LastErrorXml', @sValue OUT

Provides XML-formatted information about the last called method or property. If a method call fails or behaves unexpectedly, check this property for details. Note that information is available regardless of the method call's success.

top
LastMethodSuccess
EXEC sp_OAGetProperty @xml, 'LastMethodSuccess', @iValue OUT
EXEC sp_OASetProperty @xml, 'LastMethodSuccess', @iValue

Indicates the success or failure of the most recent method call: 1 means success, 0 means failure. This property remains unchanged by property setters or getters. This method is present to address challenges in checking for null or Nothing returns in certain programming languages. Note: This property does not apply to methods that return integer values or to boolean-returning methods where the boolean does not indicate success or failure.

top
LastStringResult
EXEC sp_OAGetProperty @xml, 'LastStringResult', @sValue OUT

In SQL Server stored procedures, this property holds the string return value of the most recent method call that returns a string. It is accessible only when Chilkat.Global.KeepStringResult is set to TRUE. SQL Server has limitations on string lengths returned from methods and properties, but temp tables can be used to access large strings.

top
LastStringResultLen
EXEC sp_OAGetProperty @xml, 'LastStringResultLen', @iValue OUT

The length, in characters, of the string contained in the LastStringResult property.

top
NumAttributes
EXEC sp_OAGetProperty @xml, 'NumAttributes', @iValue OUT

Returns the number of attributes on this element.

For example, <tag attr1="value1" attr2="value2">...</tag> has two attributes. Attribute indexes used by methods such as GetAttributeName and GetAttributeValue are zero-based.

More Information and Examples
top
NumChildren
EXEC sp_OAGetProperty @xml, 'NumChildren', @iValue OUT

Returns the number of direct child elements of this element. Descendants below those children are not included in the count.

Direct children only: Use traversal or search methods when you need to inspect the entire subtree rather than only the immediate children.

top
SortCaseInsensitive
EXEC sp_OAGetProperty @xml, 'SortCaseInsensitive', @iValue OUT
EXEC sp_OASetProperty @xml, 'SortCaseInsensitive', @iValue

Controls case sensitivity for the XML sorting methods. Set to 1 for case-insensitive string comparisons or 0 for case-sensitive comparisons.

top
Standalone
EXEC sp_OAGetProperty @xml, 'Standalone', @iValue OUT
EXEC sp_OASetProperty @xml, 'Standalone', @iValue

Controls the standalone pseudo-attribute in the XML declaration. This is a document-level setting and may be accessed from any element in the tree.

Setting this property to 1 causes the declaration to include standalone="yes".

XML declaration: The standalone declaration concerns whether the document relies on external markup declarations. It is metadata in the XML declaration; it does not by itself validate or alter the document.

top
Strict
EXEC sp_OAGetProperty @xml, 'Strict', @iValue OUT
EXEC sp_OASetProperty @xml, 'Strict', @iValue
Introduced in version 11.6.0

When Strict is true, the XML loading methods first check that the input is well-formed XML. If it is not, the load fails and the contents of this Xml object are left unchanged. The default is 0.

This applies to LoadXml, LoadXml2, LoadSb, LoadBd, LoadXmlFile and LoadXmlFile2.

Chilkat's XML parser is deliberately tolerant. By default it can accept input that is not well-formed, succeed, and leave a partially populated tree. That is convenient when the goal is a best-effort parse of imperfect input, but it is the wrong behavior when a silently dropped element or attribute changes what the application does.

Set Strict to 1 for XML carrying configuration, credentials, signed content, or security parameters, where an element that quietly failed to load would be acted on as though it had never been present.

The check is for XML 1.0 well-formedness only. It is not a validating parse: no DTD or schema is read, and the document is not checked against one. Markup declarations inside an internal DTD subset are skipped rather than parsed.

Note: The default is 0 so that existing applications are unaffected. When a strict load is rejected, this Xml object keeps whatever it held before the call, so a failed reload never leaves the object empty.

top
Tag
EXEC sp_OAGetProperty @xml, 'Tag', @sValue OUT
EXEC sp_OASetProperty @xml, 'Tag', @sValue

Gets or sets the element name for this element, including any namespace prefix. For example, the tag for <soapenv:Body> is soapenv:Body.

Use TagNsPrefix and TagUnprefixed when the prefix and local portion are needed separately.

More Information and Examples
top
TagNsPrefix
EXEC sp_OAGetProperty @xml, 'TagNsPrefix', @sValue OUT
EXEC sp_OASetProperty @xml, 'TagNsPrefix', @sValue
Introduced in version 9.5.0.77

Gets or sets the namespace prefix portion of this element's tag. For soapenv:Envelope, the namespace prefix is soapenv.

Prefix vs. namespace URI: This property deals with the lexical prefix in the tag name. A prefix is not itself the namespace URI; namespace bindings are expressed through xmlns attributes in the XML.

More Information and Examples
top
TagPath
EXEC sp_OAGetProperty @xml, 'TagPath', @sValue OUT
Introduced in version 9.5.0.77

Returns the Chilkat tag path needed to reach this element from the document root. If this object currently references the root element, the returned path is the empty string.

Not XPath: A Chilkat tag path is Chilkat's own navigation syntax, typically using | between element names. It is not an XPath expression.

More Information and Examples
top
TagUnprefixed
EXEC sp_OAGetProperty @xml, 'TagUnprefixed', @sValue OUT
EXEC sp_OASetProperty @xml, 'TagUnprefixed', @sValue
Introduced in version 9.5.0.77

Gets or sets the unprefixed portion of this element's tag. For soapenv:Envelope, the unprefixed tag is Envelope.

Use TagNsPrefix to access the prefix separately.

More Information and Examples
top
TreeId
EXEC sp_OAGetProperty @xml, 'TreeId', @iValue OUT

Returns the identifier of the XML tree to which this element belongs. Elements in the same XML document have the same TreeId.

Useful for element references: Multiple Xml objects can reference different elements in the same underlying tree. Comparing TreeId values is a convenient way to determine whether two element references belong to that same tree.

top
UncommonOptions
EXEC sp_OAGetProperty @xml, 'UncommonOptions', @sValue OUT
EXEC sp_OASetProperty @xml, 'UncommonOptions', @sValue
Introduced in version 9.5.0.90

Provides a catch-all string for uncommon XML behaviors. The default is the empty string, which is appropriate for normal use.

Leave this property empty unless Chilkat documentation or support identifies a specific option needed for a specialized interoperability case.

top
VerboseLogging
EXEC sp_OAGetProperty @xml, 'VerboseLogging', @iValue OUT
EXEC sp_OASetProperty @xml, 'VerboseLogging', @iValue

If set to 1, then the contents of LastErrorText (or LastErrorXml, or LastErrorHtml) may contain more verbose information. The default value is 0. Verbose logging should only be used for debugging. The potentially large quantity of logged information may adversely affect peformance.

top
Version
EXEC sp_OAGetProperty @xml, 'Version', @sValue OUT

Version of the component/library, such as "10.1.0"

More Information and Examples
top

Methods

AccumulateTagContent
EXEC sp_OAMethod @xml, 'AccumulateTagContent', @sResult OUT, @tag, @skipTags

Traverses the subtree rooted at the calling element and concatenates the text content of all elements whose tag equals tag.

skipTags is a vertical-bar-delimited list of tag names whose entire subtrees are excluded from the accumulation. For example, script|style skips elements rooted at either of those tags.

Returns NULL on failure

More Information and Examples
top
AddAttribute
EXEC sp_OAMethod @xml, 'AddAttribute', @success OUT, @name, @value

Adds an attribute named name with the specified string value to the calling element.

Returns 1 on success and 0 on failure.

When an attribute may already exist: Use AddOrUpdateAttribute or UpdateAttribute when the desired behavior is to update an existing attribute value instead of requiring a new attribute.

Returns 1 for success, 0 for failure.

top
AddAttributeInt
EXEC sp_OAMethod @xml, 'AddAttributeInt', @success OUT, @name, @value

Adds an attribute named name whose value is the decimal representation of value.

Returns 1 on success and 0 on failure.

Returns 1 for success, 0 for failure.

top
AddChildTree
EXEC sp_OAMethod @xml, 'AddChildTree', @success OUT, @tree

Adds the entire XML subtree referenced by tree as a new direct child of the calling element.

If tree already belongs to another XML document, the subtree is transferred to the destination tree rather than copied as an unrelated duplicate.

Tree ownership: After moving a subtree between documents, its elements belong to the destination tree. TreeId can be used to determine which tree an element reference belongs to.

Returns 1 for success, 0 for failure.

More Information and Examples
top
AddOrUpdateAttribute
EXEC sp_OAMethod @xml, 'AddOrUpdateAttribute', NULL, @name, @value

Sets the string value of an attribute on the calling element. If an attribute named name already exists, its value is replaced; otherwise the attribute is added.

More Information and Examples
top
AddOrUpdateAttributeI
EXEC sp_OAMethod @xml, 'AddOrUpdateAttributeI', NULL, @name, @value

Sets an integer-valued attribute on the calling element. If an attribute named name already exists, its value is replaced with the decimal representation of value; otherwise the attribute is added.

top
AddStyleSheet
EXEC sp_OAMethod @xml, 'AddStyleSheet', NULL, @styleSheet

Adds an XML stylesheet processing instruction to the document. Pass the complete processing-instruction text, for example:

<?xml-stylesheet href="mystyle.css" title="Compact" type="text/css"?>
Processing instruction: An XML stylesheet declaration associates stylesheet metadata with the XML document; it does not apply or execute the stylesheet.

top
AddToAttribute
EXEC sp_OAMethod @xml, 'AddToAttribute', NULL, @name, @amount

Treats the named attribute value as an integer, adds amount, and stores the resulting integer back in the attribute.

If the attribute does not yet exist, this method behaves like AddOrUpdateAttributeI and creates it with amount as the value.

More Information and Examples
top
AddToChildContent
EXEC sp_OAMethod @xml, 'AddToChildContent', NULL, @tag, @amount

Finds the child identified by tag, interprets its content as an integer, adds amount, and stores the resulting integer as the child's new content.

top
AddToContent
EXEC sp_OAMethod @xml, 'AddToContent', NULL, @amount

Interprets this element's content as an integer, adds amount, and stores the resulting integer as the new content.

top
AppendToContent
EXEC sp_OAMethod @xml, 'AppendToContent', @success OUT, @str

Appends str to the existing text content of the calling element without replacing its child elements.

Returns 1 on success and 0 on failure.

Returns 1 for success, 0 for failure.

top
ChildContentMatches
EXEC sp_OAMethod @xml, 'ChildContentMatches', @success OUT, @tagPath, @pattern, @caseSensitive

Returns 1 if the child identified by tagPath has content matching pattern; otherwise returns 0. caseSensitive controls whether letter case is significant.

The pattern may contain * wildcards, where each asterisk matches zero or more characters.

Tag paths: A tag path is Chilkat's |-separated child-navigation syntax, for example tagA|tagB|tagC. It is not XPath.

top
ChilkatPath
EXEC sp_OAMethod @xml, 'ChilkatPath', @sResult OUT, @pathCmd

Evaluates a Chilkat-specific path command that can navigate from the current element, return element content or an attribute value, or move the caller's internal element reference.

This syntax is not XPath. Commands are separated by vertical bars and the expression ends with a return command:

command|command|command|...|returnCommand

Navigation commands include:

  • TagName - first direct child having that tag.
  • TagName[n] - the indexed direct child having that tag.
  • .. - parent.
  • ++ / -- - next / previous sibling.
  • TagName{Content} - first direct child with that tag and exact content.
  • /T/TagName - traverse the subtree and find the first element with that tag.
  • /C/TagName,ContentPattern - traverse for a tag whose content matches a wildcard pattern.
  • /C/ContentPattern - traverse for any tag whose content matches a wildcard pattern.
  • /A/TagName,AttrName,AttrValuePattern - traverse for a tag having a matching attribute value.

The final return command is:

  • * - return the current element's content.
  • (AttrName) - return an attribute value.
  • $ - move this Xml object to the selected element and return an empty string.
Index substitution: The I, J, and K properties can be used with [i], [j], and [k] in path expressions.

Returns NULL on failure

top
Clear
EXEC sp_OAMethod @xml, 'Clear', NULL

Clears the calling element by removing all child elements, attributes, and text content, and resets its tag name to unnamed.

The element itself remains in the tree; this method clears its contents rather than removing the element from its parent.

top
ContentMatches
EXEC sp_OAMethod @xml, 'ContentMatches', @success OUT, @pattern, @caseSensitive

Returns 1 if this element's content matches pattern; otherwise returns 0. caseSensitive controls whether letter case is significant.

The pattern may contain * wildcards, where each asterisk matches zero or more characters.

top
Copy
EXEC sp_OAMethod @xml, 'Copy', NULL, @node

Copies the Tag, Content, and attributes from node to the calling element.

Not a subtree copy: This method does not copy the source element's children. Use a tree-oriented method such as AddChildTree or SwapTree when child structure is part of the operation.

top
CopyRef
EXEC sp_OAMethod @xml, 'CopyRef', NULL, @copyFromNode

Changes this Xml object so that it references the same underlying XML element as copyFromNode. The caller's previous element reference is discarded.

Reference operation: CopyRef does not copy XML data. After the call, both Xml objects refer to the same element, so edits through either reference affect the same tree element.

top
DecodeEntities
EXEC sp_OAMethod @xml, 'DecodeEntities', @sResult OUT, @str

Decodes HTML character entities found in str and returns the decoded text. This is a utility operation; it does not modify the XML tree unless the returned string is assigned to an element.

For example, an HTML entity such as &amp; is decoded to &.

Returns NULL on failure

More Information and Examples
top
DecryptContent
EXEC sp_OAMethod @xml, 'DecryptContent', @success OUT, @password

Decrypts element content previously produced by EncryptContent, using the same password, and restores the original plaintext content.

Returns 1 on success and 0 on failure.

Compatibility-oriented encryption: This method is paired specifically with EncryptContent. It is not a general XML Encryption (XML-Enc) implementation.

Returns 1 for success, 0 for failure.

More Information and Examples
top
EncryptContent
EXEC sp_OAMethod @xml, 'EncryptContent', @success OUT, @password

Encrypts the calling element's text content using Chilkat's password-based 128-bit AES-CBC format and replaces the plaintext content with Base64-encoded encrypted data.

Returns 1 on success and 0 on failure.

Scope: Only this element's content is encrypted. The tag, attributes, and child elements are not encrypted by this method. Use DecryptContent with the same password to restore the content.

Returns 1 for success, 0 for failure.

More Information and Examples
top
ExtractChildByIndex
EXEC sp_OAMethod @xml, 'ExtractChildByIndex', @xml OUT, @index -- returns a ChilkatXml object token

Removes the direct child at zero-based index from the calling element and returns an Xml object for the detached child subtree.

Extract vs. remove: Unlike RemoveChildByIndex, extraction gives the caller a reference to the removed subtree so it can be retained, inspected, or attached elsewhere.

Returns NULL on failure

top
ExtractChildByName
EXEC sp_OAMethod @xml, 'ExtractChildByName', @xml OUT, @tagPath, @attrName, @attrValue -- returns a ChilkatXml object token

Finds, removes, and returns the first child selected by tagPath and the optional attribute criteria.

If attrName and attrValue are empty, the first child matching the tag/path is extracted. If attrName is provided, the child must have that attribute. If attrValue is also provided, the attribute value must match exactly.

Tag paths: A tag path is Chilkat's |-separated child-navigation syntax, for example tagA|tagB|tagC. It is not XPath.

Returns NULL on failure

More Information and Examples
top
FindChild
EXEC sp_OAMethod @xml, 'FindChild', @xml OUT, @tagPath -- returns a ChilkatXml object token

Returns an Xml object referencing the child selected by tagPath. The calling object remains positioned on its current element.

Tag paths: A tag path is Chilkat's |-separated child-navigation syntax, for example tagA|tagB|tagC. It is not XPath.
Element-reference behavior: Methods that return an Xml object return another object referencing an element in the same underlying tree. Methods whose names end in 2 instead move the caller's internal reference.

Returns NULL on failure

top
FindChild2
EXEC sp_OAMethod @xml, 'FindChild2', @success OUT, @tagPath

Moves the calling Xml object's internal reference to the child selected by tagPath. Returns 1 when the child is found and the move succeeds; otherwise returns 0.

Tag paths: A tag path is Chilkat's |-separated child-navigation syntax, for example tagA|tagB|tagC. It is not XPath.
Element-reference behavior: Methods that return an Xml object return another object referencing an element in the same underlying tree. Methods whose names end in 2 instead move the caller's internal reference.

Returns 1 for success, 0 for failure.

top
FindNextRecord
EXEC sp_OAMethod @xml, 'FindNextRecord', @xml OUT, @tagPath, @contentPattern -- returns a ChilkatXml object token

Finds the next direct child record for which the descendant identified by tagPath has content matching contentPattern. This is intended for iterating record-like child elements.

The content pattern may contain * wildcards.

Tag paths: A tag path is Chilkat's |-separated child-navigation syntax, for example tagA|tagB|tagC. It is not XPath.

Returns NULL on failure

More Information and Examples
top
FindOrAddNewChild
EXEC sp_OAMethod @xml, 'FindOrAddNewChild', @xml OUT, @tagPath -- returns a ChilkatXml object token

Returns the child selected by tagPath if it already exists. If it does not exist, creates the required child path with empty content and returns the resulting child element.

Tag paths: A tag path is Chilkat's |-separated child-navigation syntax, for example tagA|tagB|tagC. It is not XPath. Use NewChild instead when duplicate children with the same tag are intentional.

Returns NULL on failure

top
FirstChild
EXEC sp_OAMethod @xml, 'FirstChild', @xml OUT -- returns a ChilkatXml object token

Returns an Xml object referencing the first direct child of the calling element.

A common forward-iteration pattern is FirstChild followed by repeated calls to NextSibling.

Element-reference behavior: Methods that return an Xml object return another object referencing an element in the same underlying tree. Methods whose names end in 2 instead move the caller's internal reference.

Returns NULL on failure

top
FirstChild2
EXEC sp_OAMethod @xml, 'FirstChild2', @success OUT

Moves the calling Xml object's internal reference to its first direct child. Returns 1 if a first child exists; otherwise returns 0.

Element-reference behavior: Methods that return an Xml object return another object referencing an element in the same underlying tree. Methods whose names end in 2 instead move the caller's internal reference.

Returns 1 for success, 0 for failure.

top
GetAttributeName
EXEC sp_OAMethod @xml, 'GetAttributeName', @sResult OUT, @index

Returns the name of the attribute at zero-based index. Use NumAttributes to determine the valid index range.

Returns NULL on failure

More Information and Examples
top
GetAttributeValue
EXEC sp_OAMethod @xml, 'GetAttributeValue', @sResult OUT, @index

Returns the value of the attribute at zero-based index. Use NumAttributes to determine the valid index range.

Returns NULL on failure

More Information and Examples
top
GetAttributeValueInt
EXEC sp_OAMethod @xml, 'GetAttributeValueInt', @iResult OUT, @index

Returns the value of the attribute at zero-based index, interpreted as a 32-bit integer.

top
GetAttrValue
EXEC sp_OAMethod @xml, 'GetAttrValue', @sResult OUT, @name

Returns the value of the attribute named name on the calling element.

Use HasAttribute when the application must distinguish a missing attribute from an attribute whose value is empty.

Returns NULL on failure

More Information and Examples
top
GetAttrValueInt
EXEC sp_OAMethod @xml, 'GetAttrValueInt', @iResult OUT, @name

Returns the value of the attribute named name interpreted as a 32-bit integer. Returns 0 if the attribute does not exist.

Ambiguous zero: Because a missing attribute and an attribute containing zero can both yield 0, call HasAttribute first when that distinction matters.

More Information and Examples
top
GetChild
EXEC sp_OAMethod @xml, 'GetChild', @xml OUT, @index -- returns a ChilkatXml object token

Returns an Xml object referencing the direct child at zero-based index. The calling object remains positioned on its current element.

Use NumChildren to determine the valid child range.

Element-reference behavior: Methods that return an Xml object return another object referencing an element in the same underlying tree. Methods whose names end in 2 instead move the caller's internal reference.

Returns NULL on failure

More Information and Examples
top
GetChild2
EXEC sp_OAMethod @xml, 'GetChild2', @success OUT, @index

Moves the calling Xml object's internal reference to the direct child at zero-based index. Returns 1 on success and 0 if the child cannot be selected.

Element-reference behavior: Methods that return an Xml object return another object referencing an element in the same underlying tree. Methods whose names end in 2 instead move the caller's internal reference.

Returns 1 for success, 0 for failure.

top
GetChildAttrValue
EXEC sp_OAMethod @xml, 'GetChildAttrValue', @sResult OUT, @tagPath, @attrName
Introduced in version 9.5.0.77

Returns the value of attribute attrName on the descendant element selected by tagPath.

Tag paths: A tag path is Chilkat's |-separated child-navigation syntax, for example tagA|tagB|tagC. It is not XPath.

Returns NULL on failure

top
GetChildBoolValue
EXEC sp_OAMethod @xml, 'GetChildBoolValue', @success OUT, @tagPath

Returns the integer content of the child selected by tagPath as a Boolean value: content equal to 0 yields 0; a non-zero integer yields 1.

Tag paths: A tag path is Chilkat's |-separated child-navigation syntax, for example tagA|tagB|tagC. It is not XPath.

More Information and Examples
top
GetChildContent
EXEC sp_OAMethod @xml, 'GetChildContent', @sResult OUT, @tagPath

Returns the text content of the child selected by tagPath.

Tag paths: A tag path is Chilkat's |-separated child-navigation syntax, for example tagA|tagB|tagC. It is not XPath.
Content only: The returned value is the child element's direct Content; nested child elements are not serialized into this string.

Returns NULL on failure

More Information and Examples
top
GetChildContentByIndex
EXEC sp_OAMethod @xml, 'GetChildContentByIndex', @sResult OUT, @index

Returns the text content of the direct child at zero-based index. Use NumChildren to determine the valid range.

Returns NULL on failure

top
GetChildContentSb
EXEC sp_OAMethod @xml, 'GetChildContentSb', @success OUT, @tagPath, @sb
Introduced in version 9.5.0.76

Finds the element selected by tagPath and appends that element's text content to sb.

The existing contents of the StringBuilder are preserved.

Tag paths: A tag path is Chilkat's |-separated child-navigation syntax, for example tagA|tagB|tagC. It is not XPath.

Returns 1 on success and 0 on failure.

Returns 1 for success, 0 for failure.

top
GetChildExact
EXEC sp_OAMethod @xml, 'GetChildExact', @xml OUT, @tag, @content -- returns a ChilkatXml object token

Returns the first direct child whose tag equals tag and whose text content exactly equals content.

The calling object remains positioned on its current element.

Returns NULL on failure

top
GetChildIntValue
EXEC sp_OAMethod @xml, 'GetChildIntValue', @iResult OUT, @tagPath

Returns the content of the child selected by tagPath, interpreted as a 32-bit integer.

Tag paths: A tag path is Chilkat's |-separated child-navigation syntax, for example tagA|tagB|tagC. It is not XPath.
Integer range: Use GetChildContent and parse the returned text separately when values may exceed the range of a 32-bit integer.

top
GetChildTag
EXEC sp_OAMethod @xml, 'GetChildTag', @sResult OUT, @index

Returns the tag name of the direct child at zero-based index. Use NumChildren to determine the valid index range.

Returns NULL on failure

top
GetChildTagByIndex
EXEC sp_OAMethod @xml, 'GetChildTagByIndex', @sResult OUT, @index

Returns the tag name of the direct child at zero-based index. Use NumChildren to determine the valid index range.

Returns NULL on failure

More Information and Examples
top
GetChildWithAttr
EXEC sp_OAMethod @xml, 'GetChildWithAttr', @xml OUT, @tagPath, @attrName, @attrValue -- returns a ChilkatXml object token

Returns the child selected by tagPath that also has an attribute named attrName whose value exactly equals attrValue.

Tag paths: A tag path is Chilkat's |-separated child-navigation syntax, for example tagA|tagB|tagC. It is not XPath.

Returns NULL on failure

More Information and Examples
top
GetChildWithContent
EXEC sp_OAMethod @xml, 'GetChildWithContent', @xml OUT, @content -- returns a ChilkatXml object token

Returns the first direct child whose text content exactly equals content. The child tag may be any value.

Returns NULL on failure

top
GetChildWithTag
EXEC sp_OAMethod @xml, 'GetChildWithTag', @xml OUT, @tagPath -- returns a ChilkatXml object token

Returns an Xml object referencing the child selected by tagPath. The calling object remains positioned on its current element.

Tag paths: A tag path is Chilkat's |-separated child-navigation syntax, for example tagA|tagB|tagC. It is not XPath.
Element-reference behavior: Methods that return an Xml object return another object referencing an element in the same underlying tree. Methods whose names end in 2 instead move the caller's internal reference.

Returns NULL on failure

top
GetChildWithTag2
EXEC sp_OAMethod @xml, 'GetChildWithTag2', @success OUT, @tagPath
Introduced in version 11.1.0

Moves the calling Xml object's internal reference to the child selected by tagPath. Returns 1 when the child is found and the move succeeds; otherwise returns 0.

Tag paths: A tag path is Chilkat's |-separated child-navigation syntax, for example tagA|tagB|tagC. It is not XPath.
Element-reference behavior: Methods that return an Xml object return another object referencing an element in the same underlying tree. Methods whose names end in 2 instead move the caller's internal reference.

Returns 1 for success, 0 for failure.

top
GetNthChildWithTag
EXEC sp_OAMethod @xml, 'GetNthChildWithTag', @xml OUT, @tag, @n -- returns a ChilkatXml object token

Returns the zero-based nth direct child whose tag exactly equals tag. Children with other tag names are ignored when counting matches.

Use NumChildrenHavingTag to determine how many matching children are available.

Returns NULL on failure

top
GetNthChildWithTag2
EXEC sp_OAMethod @xml, 'GetNthChildWithTag2', @success OUT, @tag, @n

Moves the calling Xml object's internal reference to the zero-based nth direct child whose tag equals tag. Returns 1 on success and 0 when no such child exists.

Element-reference behavior: Methods that return an Xml object return another object referencing an element in the same underlying tree. Methods whose names end in 2 instead move the caller's internal reference.

Returns 1 for success, 0 for failure.

top
GetParent
EXEC sp_OAMethod @xml, 'GetParent', @xml OUT -- returns a ChilkatXml object token

Returns an Xml object referencing this element's parent. Returns no parent when the current element is the document root.

Element-reference behavior: Methods that return an Xml object return another object referencing an element in the same underlying tree. Methods whose names end in 2 instead move the caller's internal reference.

Returns NULL on failure

top
GetParent2
EXEC sp_OAMethod @xml, 'GetParent2', @success OUT

Moves the calling Xml object's internal reference to its parent. Returns 1 if a parent exists; otherwise returns 0 when already at the root.

Element-reference behavior: Methods that return an Xml object return another object referencing an element in the same underlying tree. Methods whose names end in 2 instead move the caller's internal reference.

Returns 1 for success, 0 for failure.

top
GetRoot
EXEC sp_OAMethod @xml, 'GetRoot', @xml OUT -- returns a ChilkatXml object token

Returns an Xml object referencing the root element of the XML tree that contains the current element. The calling object remains positioned on its current element.

Element-reference behavior: Methods that return an Xml object return another object referencing an element in the same underlying tree. Methods whose names end in 2 instead move the caller's internal reference.

Returns NULL on failure

top
GetRoot2
EXEC sp_OAMethod @xml, 'GetRoot2', NULL

Moves the calling Xml object's internal reference to the root element of its XML tree.

Element-reference behavior: Methods that return an Xml object return another object referencing an element in the same underlying tree. Methods whose names end in 2 instead move the caller's internal reference.

top
GetSelf
EXEC sp_OAMethod @xml, 'GetSelf', @xml OUT -- returns a ChilkatXml object token

Returns a new Xml object that references the same underlying XML element as the calling object.

Shared element reference: This is not a deep copy. Both objects reference the same element, so changes made through either object are changes to the same XML tree.

Returns NULL on failure

top
GetXml
EXEC sp_OAMethod @xml, 'GetXml', @sResult OUT

Serializes the XML tree or subtree rooted at the current element and returns the XML text.

When called while positioned on the document root, the XML declaration is included if EmitXmlDecl is 1. When called on a non-root element, only that subtree is emitted and the document declaration is not included.

EmitCompact, Encoding, Standalone, and related document/output properties affect serialization as applicable.

String vs. bytes: A language string is Unicode text. The Encoding declaration describes serialized XML encoding, while actual byte encoding matters when XML is written to a file or byte-oriented destination.

Returns NULL on failure

top
GetXmlBd
EXEC sp_OAMethod @xml, 'GetXmlBd', @success OUT, @bd
Introduced in version 9.5.0.77

Serializes the XML tree or subtree rooted at the current element and appends the encoded XML bytes to bd.

The existing contents of the BinData object are preserved. The XML output encoding is governed by the XML document's output settings, including Encoding.

Returns 1 on success and 0 on failure.

Returns 1 for success, 0 for failure.

top
GetXmlSb
EXEC sp_OAMethod @xml, 'GetXmlSb', @success OUT, @sb
Introduced in version 9.5.0.62

Serializes the XML tree or subtree rooted at the current element and appends the resulting XML text to sb.

The existing contents of sb are preserved. Output properties such as EmitCompact and EmitXmlDecl apply as appropriate.

Returns 1 on success and 0 on failure.

Returns 1 for success, 0 for failure.

top
HasAttribute
EXEC sp_OAMethod @xml, 'HasAttribute', @success OUT, @name

Returns 1 if the calling element has an attribute named name; otherwise returns 0.

top
HasAttrWithValue
EXEC sp_OAMethod @xml, 'HasAttrWithValue', @success OUT, @name, @value

Returns 1 if the calling element has an attribute named name whose value exactly equals value; otherwise returns 0.

top
HasChildWithContent
EXEC sp_OAMethod @xml, 'HasChildWithContent', @success OUT, @content

Returns 1 if any direct child has text content exactly equal to content; otherwise returns 0.

top
HasChildWithTag
EXEC sp_OAMethod @xml, 'HasChildWithTag', @success OUT, @tagPath

Returns 1 if the child selected by tagPath exists; otherwise returns 0.

Tag paths: A tag path is Chilkat's |-separated child-navigation syntax, for example tagA|tagB|tagC. It is not XPath.

More Information and Examples
top
HasChildWithTagAndContent
EXEC sp_OAMethod @xml, 'HasChildWithTagAndContent', @success OUT, @tagPath, @content

Returns 1 if the child selected by tagPath exists and its text content exactly equals content; otherwise returns 0.

Tag paths: A tag path is Chilkat's |-separated child-navigation syntax, for example tagA|tagB|tagC. It is not XPath.

top
InsertChildTreeAfter
EXEC sp_OAMethod @xml, 'InsertChildTreeAfter', NULL, @index, @tree

Inserts the entire subtree referenced by tree as a direct child immediately after the existing child at zero-based index.

If tree belongs to another XML document, the subtree is transferred to the destination tree.

Structural move: The operation preserves the subtree structure. The supplied tree is not flattened into text content.

top
InsertChildTreeBefore
EXEC sp_OAMethod @xml, 'InsertChildTreeBefore', NULL, @index, @tree

Inserts the entire subtree referenced by tree as a direct child immediately before the existing child at zero-based index.

If tree belongs to another XML document, the subtree is transferred to the destination tree.

Structural move: The operation preserves the subtree structure. The supplied tree is not flattened into text content.

More Information and Examples
top
LastChild
EXEC sp_OAMethod @xml, 'LastChild', @xml OUT -- returns a ChilkatXml object token

Returns an Xml object referencing the last direct child of the calling element.

A common reverse-iteration pattern is LastChild followed by repeated calls to PreviousSibling.

Element-reference behavior: Methods that return an Xml object return another object referencing an element in the same underlying tree. Methods whose names end in 2 instead move the caller's internal reference.

Returns NULL on failure

top
LastChild2
EXEC sp_OAMethod @xml, 'LastChild2', @success OUT

Moves the calling Xml object's internal reference to its last direct child. Returns 1 if a last child exists; otherwise returns 0.

Element-reference behavior: Methods that return an Xml object return another object referencing an element in the same underlying tree. Methods whose names end in 2 instead move the caller's internal reference.

Returns 1 for success, 0 for failure.

top
LoadBd
EXEC sp_OAMethod @xml, 'LoadBd', @success OUT, @bd, @autoTrim
Introduced in version 9.5.0.77

Parses XML from the bytes contained in bd and replaces the calling object's current XML tree with the loaded document.

If autoTrim is 1, leading and trailing whitespace is removed from each leaf element's text content during loading.

Returns 1 on success and 0 on failure.

Returns 1 for success, 0 for failure.

top
LoadSb
EXEC sp_OAMethod @xml, 'LoadSb', @success OUT, @sb, @autoTrim
Introduced in version 9.5.0.62

Parses XML from the current contents of sb and replaces the calling object's current XML tree with the loaded document.

If autoTrim is 1, leading and trailing whitespace is removed from each leaf element's text content while loading.

Returns 1 on success and 0 on failure.

Returns 1 for success, 0 for failure.

More Information and Examples
top
LoadXml
EXEC sp_OAMethod @xml, 'LoadXml', @success OUT, @xmlData

Parses the XML text in xmlData and replaces the calling object's current XML tree content with the loaded document root. Returns 1 if parsing succeeds.

Replacement operation: A successful load replaces the current document/tree state represented by this object; it does not append the loaded XML beneath the current element.

Returns 1 for success, 0 for failure.

top
LoadXml2
EXEC sp_OAMethod @xml, 'LoadXml2', @success OUT, @xmlData, @autoTrim

Parses the XML text in xmlData and replaces the current XML tree, like LoadXml. The autoTrim argument additionally controls whether leading and trailing whitespace is removed from each leaf element's text content while loading.

Whitespace significance: Set autoTrim to 0 when leading or trailing text whitespace is significant to the application.

Returns 1 for success, 0 for failure.

More Information and Examples
top
LoadXmlFile
EXEC sp_OAMethod @xml, 'LoadXmlFile', @success OUT, @fileName

Reads and parses an XML document from fileName, replacing the calling object's current XML tree with the loaded document root. Returns 1 on success.

The file's XML declaration and byte encoding are used as part of normal XML parsing.

Returns 1 for success, 0 for failure.

top
LoadXmlFile2
EXEC sp_OAMethod @xml, 'LoadXmlFile2', @success OUT, @fileName, @autoTrim

Reads and parses an XML document from fileName, replacing the current XML tree. The autoTrim argument controls whether leading and trailing whitespace is removed from each leaf element's text content.

Whitespace significance: Set autoTrim to 0 when leading or trailing text whitespace must be preserved exactly.

Returns 1 for success, 0 for failure.

More Information and Examples
top
NewChild
EXEC sp_OAMethod @xml, 'NewChild', @xml OUT, @tagPath, @content -- returns a ChilkatXml object token

Creates and returns a new child at tagPath with the specified text content. A new child is created even when a child with the same tag already exists.

Tag paths: A tag path is Chilkat's |-separated child-navigation syntax, for example tagA|tagB|tagC. It is not XPath. Intermediate elements in a multi-part path are created as needed. Use FindOrAddNewChild when duplicate final children should be avoided.

Returns NULL on failure

top
NewChild2
EXEC sp_OAMethod @xml, 'NewChild2', NULL, @tagPath, @content

Creates a new child at tagPath with the specified text content, but does not return a separate Xml object for the new element.

Tag paths: A tag path is Chilkat's |-separated child-navigation syntax, for example tagA|tagB|tagC. It is not XPath. Intermediate elements in a multi-part path are created as needed.

top
NewChildAfter
EXEC sp_OAMethod @xml, 'NewChildAfter', @xml OUT, @index, @tag, @content -- returns a ChilkatXml object token

Creates a new direct child with the specified tag and content, inserts it immediately after the child at zero-based index, and returns the new child element.

Returns NULL on failure

More Information and Examples
top
NewChildBefore
EXEC sp_OAMethod @xml, 'NewChildBefore', @xml OUT, @index, @tag, @content -- returns a ChilkatXml object token

Creates a new direct child with the specified tag and content, inserts it immediately before the child at zero-based index, and returns the new child element.

Returns NULL on failure

More Information and Examples
top
NewChildInt2
EXEC sp_OAMethod @xml, 'NewChildInt2', NULL, @tagPath, @value

Creates a new child at tagPath whose content is the decimal representation of value. No separate child object is returned.

Tag paths: A tag path is Chilkat's |-separated child-navigation syntax, for example tagA|tagB|tagC. It is not XPath. Intermediate elements in a multi-part path are created as needed.

More Information and Examples
top
NextInTraversal2
EXEC sp_OAMethod @xml, 'NextInTraversal2', @success OUT, @sbState
Introduced in version 9.5.0.77

Moves the calling Xml object to the next element in a depth-first traversal of the tree and updates sbState with the traversal state.

Pass an empty StringBuilder when beginning a traversal, then reuse the same sbState for each subsequent call.

Why the name ends in 2: This method changes the caller's internal element reference. There is no separate NextInTraversal method that returns another Xml object.

More Information and Examples
top
NextSibling
EXEC sp_OAMethod @xml, 'NextSibling', @xml OUT -- returns a ChilkatXml object token

Returns an Xml object referencing the current element's next sibling, or no object when there is no next sibling.

Element-reference behavior: Methods that return an Xml object return another object referencing an element in the same underlying tree. Methods whose names end in 2 instead move the caller's internal reference.

Returns NULL on failure

top
NextSibling2
EXEC sp_OAMethod @xml, 'NextSibling2', @success OUT

Moves the calling Xml object's internal reference to its next sibling. Returns 1 if one exists; otherwise returns 0.

Element-reference behavior: Methods that return an Xml object return another object referencing an element in the same underlying tree. Methods whose names end in 2 instead move the caller's internal reference.

Returns 1 for success, 0 for failure.

top
NumChildrenAt
EXEC sp_OAMethod @xml, 'NumChildrenAt', @iResult OUT, @tagPath
Introduced in version 9.5.0.64

Returns the number of direct children of the element selected by tagPath. Returns -1 if the path does not identify an existing element.

Tag paths: A tag path is Chilkat's |-separated child-navigation syntax, for example tagA|tagB|tagC. It is not XPath.

top
NumChildrenHavingTag
EXEC sp_OAMethod @xml, 'NumChildrenHavingTag', @iResult OUT, @tag

Returns the number of direct children whose tag exactly equals tag. Descendants below those children are not included.

top
PreviousSibling
EXEC sp_OAMethod @xml, 'PreviousSibling', @xml OUT -- returns a ChilkatXml object token

Returns an Xml object referencing the current element's previous sibling, or no object when there is no previous sibling.

Element-reference behavior: Methods that return an Xml object return another object referencing an element in the same underlying tree. Methods whose names end in 2 instead move the caller's internal reference.

Returns NULL on failure

top
PreviousSibling2
EXEC sp_OAMethod @xml, 'PreviousSibling2', @success OUT

Moves the calling Xml object's internal reference to its previous sibling. Returns 1 if one exists; otherwise returns 0.

Element-reference behavior: Methods that return an Xml object return another object referencing an element in the same underlying tree. Methods whose names end in 2 instead move the caller's internal reference.

Returns 1 for success, 0 for failure.

top
PruneAttribute
EXEC sp_OAMethod @xml, 'PruneAttribute', @iResult OUT, @attrName
Introduced in version 9.5.0.77

Recursively traverses the subtree rooted at the calling element and removes every occurrence of the attribute named attrName.

Returns the number of attributes removed.

top
PruneTag
EXEC sp_OAMethod @xml, 'PruneTag', @iResult OUT, @tag
Introduced in version 9.5.0.77

Recursively traverses the subtree rooted at the calling element and removes every element whose tag equals tag. Each removed element's entire descendant subtree is removed with it.

Returns the number of matching tag occurrences removed.

Subtree pruning: When a matching parent is removed, its descendants disappear as part of that subtree; this method is intended for structural cleanup rather than text-only removal.

More Information and Examples
top
RemoveAllAttributes
EXEC sp_OAMethod @xml, 'RemoveAllAttributes', @success OUT

Removes every attribute from the calling element. Returns 1 on success.

Returns 1 for success, 0 for failure.

top
RemoveAllChildren
EXEC sp_OAMethod @xml, 'RemoveAllChildren', NULL

Removes all direct child elements and their subtrees from the calling element. The calling element's own tag, attributes, and text content are retained.

top
RemoveAttribute
EXEC sp_OAMethod @xml, 'RemoveAttribute', @success OUT, @name

Removes the attribute named name from the calling element. Returns 1 when the operation succeeds.

Returns 1 for success, 0 for failure.

top
RemoveChild
EXEC sp_OAMethod @xml, 'RemoveChild', NULL, @tagPath

Removes all child elements selected by tagPath beneath the calling element.

Tag paths: A tag path is Chilkat's |-separated child-navigation syntax, for example tagA|tagB|tagC. It is not XPath.
All matches: This method removes matching children rather than returning a removed subtree. Use an ExtractChild... method when the removed element must be retained.

top
RemoveChildByIndex
EXEC sp_OAMethod @xml, 'RemoveChildByIndex', NULL, @index

Removes the direct child at zero-based index, including that child's entire subtree.

More Information and Examples
top
RemoveChildWithContent
EXEC sp_OAMethod @xml, 'RemoveChildWithContent', NULL, @content

Removes all direct children whose text content exactly equals content, including each removed child's subtree.

More Information and Examples
top
RemoveFromTree
EXEC sp_OAMethod @xml, 'RemoveFromTree', NULL

Detaches the calling element and its entire subtree from its parent. The detached element becomes the root of its own independent XML tree.

Object remains usable: This method removes the subtree from its former document but keeps the calling Xml object referencing the detached subtree.

More Information and Examples
top
RemoveStyleSheet
EXEC sp_OAMethod @xml, 'RemoveStyleSheet', @iResult OUT, @attrName, @attrValue
Introduced in version 9.5.0.77

Removes XML stylesheet processing instructions whose attribute named attrName has the value attrValue.

Returns the number of matching stylesheet declarations removed, or -1 if an error occurs.

top
SaveBinaryContent
EXEC sp_OAMethod @xml, 'SaveBinaryContent', @success OUT, @filename, @unzipFlag, @decryptFlag, @password

Decodes the binary content stored in this element and writes the resulting bytes to filename. Set unzipFlag and decryptFlag to reverse the transformations originally applied, and supply the corresponding password when decrypting.

Returns 1 on success and 0 on failure.

Returns 1 for success, 0 for failure.

top
SaveXml
EXEC sp_OAMethod @xml, 'SaveXml', @success OUT, @fileName

Serializes the XML tree or subtree rooted at the current element and writes it to fileName.

Document/output properties such as Encoding, EmitBom, EmitXmlDecl, and EmitCompact affect the generated output as applicable.

Returns 1 on success and 0 on failure.

Returns 1 for success, 0 for failure.

top
Scrub
EXEC sp_OAMethod @xml, 'Scrub', NULL, @directives
Introduced in version 9.5.0.77

Recursively normalizes the XML subtree rooted at the calling element according to the comma-separated keywords in directives.

Supported directives are:

  • AttrTrimEnds - remove leading and trailing whitespace from attribute values.
  • AttrTrimInside - replace tabs, CR, and LF with spaces and collapse repeated spaces inside attribute values.
  • ContentTrimEnds - remove leading and trailing whitespace from element content.
  • ContentTrimInside - normalize internal tabs/line breaks/spaces in element content.
  • LowercaseAttrs - convert attribute names to lowercase.
  • LowercaseTags - convert tag names to lowercase.
  • RemoveCtrl - remove US-ASCII control characters with values 0-31 except TAB, CR, and LF.
Destructive normalization: Scrubbing modifies the tree. Use these options only when the corresponding whitespace, letter case, or control characters are not semantically significant to the application.

More Information and Examples
top
SearchAllForContent
EXEC sp_OAMethod @xml, 'SearchAllForContent', @xml OUT, @afterPtr, @contentPattern -- returns a ChilkatXml object token

Returns the first element whose text content matches contentPattern, regardless of tag name.

The search is breadth-first within the subtree rooted at the caller. The afterPtr argument identifies the element after which matching should begin, allowing repeated calls to continue an iteration. To begin at the first candidate, use NULL where the language binding permits it; ActiveX callers should pass a reference to the caller's element instead.

Wildcard patterns are case-sensitive and may contain *, where each asterisk matches zero or more characters.

Iteration: Pass the element returned by one call as afterPtr on the next call to continue to the next match. Continue until no further element is returned.

Returns NULL on failure

More Information and Examples
top
SearchAllForContent2
EXEC sp_OAMethod @xml, 'SearchAllForContent2', @success OUT, @afterPtr, @contentPattern

Performs the same breadth-first content search as SearchAllForContent, but moves the calling Xml object's internal reference to the matching element instead of returning a separate element object.

The search is breadth-first within the subtree rooted at the caller. The afterPtr argument identifies the element after which matching should begin, allowing repeated calls to continue an iteration. To begin at the first candidate, use NULL where the language binding permits it; ActiveX callers should pass a reference to the caller's element instead.

Wildcard patterns are case-sensitive and may contain *, where each asterisk matches zero or more characters.

Element-reference behavior: Methods that return an Xml object return another object referencing an element in the same underlying tree. Methods whose names end in 2 instead move the caller's internal reference.

Returns 1 for success, 0 for failure.

top
SearchForAttribute
EXEC sp_OAMethod @xml, 'SearchForAttribute', @xml OUT, @afterPtr, @tag, @attr, @valuePattern -- returns a ChilkatXml object token

Returns the first element whose tag equals tag, that has an attribute named attr, and whose attribute value matches valuePattern.

The search is breadth-first within the subtree rooted at the caller. The afterPtr argument identifies the element after which matching should begin, allowing repeated calls to continue an iteration. To begin at the first candidate, use NULL where the language binding permits it; ActiveX callers should pass a reference to the caller's element instead.

Wildcard patterns are case-sensitive and may contain *, where each asterisk matches zero or more characters.

Iteration: Pass the previous match as afterPtr to continue searching after that element.

Returns NULL on failure

top
SearchForAttribute2
EXEC sp_OAMethod @xml, 'SearchForAttribute2', @success OUT, @afterPtr, @tag, @attr, @valuePattern

Performs the same breadth-first tag/attribute search as SearchForAttribute, but moves the calling Xml object's internal reference to the matching element instead of returning a separate object.

The search is breadth-first within the subtree rooted at the caller. The afterPtr argument identifies the element after which matching should begin, allowing repeated calls to continue an iteration. To begin at the first candidate, use NULL where the language binding permits it; ActiveX callers should pass a reference to the caller's element instead.

Wildcard patterns are case-sensitive and may contain *, where each asterisk matches zero or more characters.

Element-reference behavior: Methods that return an Xml object return another object referencing an element in the same underlying tree. Methods whose names end in 2 instead move the caller's internal reference.

Returns 1 for success, 0 for failure.

top
SearchForContent
EXEC sp_OAMethod @xml, 'SearchForContent', @xml OUT, @afterPtr, @tag, @contentPattern -- returns a ChilkatXml object token

Returns the first element whose tag equals tag and whose text content matches contentPattern.

The search is breadth-first within the subtree rooted at the caller. The afterPtr argument identifies the element after which matching should begin, allowing repeated calls to continue an iteration. To begin at the first candidate, use NULL where the language binding permits it; ActiveX callers should pass a reference to the caller's element instead.

Wildcard patterns are case-sensitive and may contain *, where each asterisk matches zero or more characters.

Iteration: Pass the previous match as afterPtr to continue searching after that element.

Returns NULL on failure

More Information and Examples
top
SearchForContent2
EXEC sp_OAMethod @xml, 'SearchForContent2', @success OUT, @afterPtr, @tag, @contentPattern

Performs the same breadth-first tag/content search as SearchForContent, but moves the calling Xml object's internal reference to the matching element.

The search is breadth-first within the subtree rooted at the caller. The afterPtr argument identifies the element after which matching should begin, allowing repeated calls to continue an iteration. To begin at the first candidate, use NULL where the language binding permits it; ActiveX callers should pass a reference to the caller's element instead.

Wildcard patterns are case-sensitive and may contain *, where each asterisk matches zero or more characters.

Element-reference behavior: Methods that return an Xml object return another object referencing an element in the same underlying tree. Methods whose names end in 2 instead move the caller's internal reference.

Returns 1 for success, 0 for failure.

More Information and Examples
top
SearchForTag
EXEC sp_OAMethod @xml, 'SearchForTag', @xml OUT, @afterPtr, @tag -- returns a ChilkatXml object token

Returns the first element whose tag exactly equals tag.

The search is breadth-first within the subtree rooted at the caller. afterPtr identifies the element after which searching begins. To begin at the first candidate, use NULL where the language binding permits it; ActiveX callers should pass a reference to the caller's element.

Iteration: Pass the previous match as afterPtr to find the next matching tag. Continue until no further element is returned.

Returns NULL on failure

top
SearchForTag2
EXEC sp_OAMethod @xml, 'SearchForTag2', @success OUT, @afterPtr, @tag

Performs the same breadth-first tag search as SearchForTag, but moves the calling Xml object's internal reference to the matching element instead of returning a separate object.

Use afterPtr in the same way as with SearchForTag to begin or continue the search.

Element-reference behavior: Methods that return an Xml object return another object referencing an element in the same underlying tree. Methods whose names end in 2 instead move the caller's internal reference.

Returns 1 for success, 0 for failure.

More Information and Examples
top
SetBinaryContentBd
EXEC sp_OAMethod @xml, 'SetBinaryContentBd', @success OUT, @data, @zipFlag, @encryptFlag, @password
Introduced in version 11.0.0

Stores the bytes in data as binary content on this element, with optional ZIP compression and optional password-based AES encryption. The stored binary representation is emitted as Base64 text when XML is serialized.

If zipFlag is 1, the bytes are compressed first. If encryptFlag is 1, the data is encrypted using Chilkat's 128-bit Rijndael/AES format and password.

Returns 1 on success and 0 on failure.

Round trip: Use the corresponding binary-content retrieval methods with matching decompression/decryption options to recover the original bytes.

Returns 1 for success, 0 for failure.

top
SetBinaryContentFromFile
EXEC sp_OAMethod @xml, 'SetBinaryContentFromFile', @success OUT, @filename, @zipFlag, @encryptFlag, @password

Reads the bytes from filename and stores them as this element's binary content, with optional ZIP compression and optional password-based encryption. The resulting stored data is represented as Base64 when XML text is generated.

Returns 1 on success and 0 on failure.

Returns 1 for success, 0 for failure.

top
SortByAttribute
EXEC sp_OAMethod @xml, 'SortByAttribute', NULL, @attrName, @ascending

Sorts the calling element's direct children by the string value of attribute attrName. Set ascending to 1 for ascending order or 0 for descending order.

SortCaseInsensitive controls case sensitivity for string sorting.

top
SortByAttributeInt
EXEC sp_OAMethod @xml, 'SortByAttributeInt', NULL, @attrName, @ascending

Sorts the calling element's direct children numerically by the value of attribute attrName, interpreting each sort value as an integer rather than comparing the text lexicographically.

Set ascending to 1 for ascending order or 0 for descending order.

top
SortByContent
EXEC sp_OAMethod @xml, 'SortByContent', NULL, @ascending

Sorts the calling element's direct children by their text content. Set ascending to 1 for ascending order or 0 for descending order.

SortCaseInsensitive controls case sensitivity for the string comparison.

More Information and Examples
top
SortByTag
EXEC sp_OAMethod @xml, 'SortByTag', NULL, @ascending

Sorts the calling element's direct children by tag name. Set ascending to 1 for ascending order or 0 for descending order.

SortCaseInsensitive controls case sensitivity for the tag-name comparison.

More Information and Examples
top
SortRecordsByAttribute
EXEC sp_OAMethod @xml, 'SortRecordsByAttribute', NULL, @sortTag, @attrName, @ascending

Treats each direct child as a record and sorts those records by the value of attribute attrName on the record's child identified by sortTag.

Set ascending to 1 for ascending order or 0 for descending order. String comparisons honor SortCaseInsensitive.

top
SortRecordsByContent
EXEC sp_OAMethod @xml, 'SortRecordsByContent', NULL, @sortTag, @ascending

Treats each direct child as a record and sorts those records by the text content of the record's child named sortTag.

Set ascending to 1 for ascending order or 0 for descending order. String comparisons honor SortCaseInsensitive.

More Information and Examples
top
SortRecordsByContentInt
EXEC sp_OAMethod @xml, 'SortRecordsByContentInt', NULL, @sortTag, @ascending

Treats each direct child as a record and sorts those records numerically by the integer content of the record's child named sortTag.

Numeric comparison is used instead of lexicographic string comparison. Set ascending to 1 for ascending order or 0 for descending order.

top
SwapNode
EXEC sp_OAMethod @xml, 'SwapNode', @success OUT, @node

Swaps the calling element's tag, text content, and attributes with those of node.

Returns 1 on success and 0 on failure.

Children are not swapped: Use SwapTree when child subtrees should also be exchanged.

Returns 1 for success, 0 for failure.

top
SwapTree
EXEC sp_OAMethod @xml, 'SwapTree', @success OUT, @tree

Swaps the calling element's complete tree state with tree, including tag, text content, attributes, and children.

Returns 1 on success and 0 on failure.

Returns 1 for success, 0 for failure.

top
TagContent
EXEC sp_OAMethod @xml, 'TagContent', @sResult OUT, @tagName

Searches the subtree rooted at the calling element for the first element whose tag equals tagName and returns that element's text content.

Recursive search: Unlike direct-child getters, this search is not limited to the caller's immediate children.

Returns NULL on failure

top
TagEquals
EXEC sp_OAMethod @xml, 'TagEquals', @success OUT, @tag

Returns 1 if the calling element's complete tag name, including any namespace prefix, exactly equals tag; otherwise returns 0.

top
TagIndex
EXEC sp_OAMethod @xml, 'TagIndex', @iResult OUT, @tagPath
Introduced in version 9.5.0.76

Returns the zero-based child index of the element selected by tagPath. Returns -1 when no matching element is found at that path.

Tag paths: A tag path is Chilkat's |-separated child-navigation syntax, for example tagA|tagB|tagC. It is not XPath.
Index meaning: The returned index is the element's position among its parent's direct children, which is the index accepted by methods such as GetChild, RemoveChildByIndex, and the insertion methods.

More Information and Examples
top
TagNsEquals
EXEC sp_OAMethod @xml, 'TagNsEquals', @success OUT, @ns
Introduced in version 9.5.0.77

Returns 1 if this element's namespace-prefix portion exactly equals ns; otherwise returns 0.

For example, the namespace prefix of soapenv:Body is soapenv.

Prefix comparison: This compares the lexical prefix, not the namespace URI bound to that prefix.

More Information and Examples
top
TagUnpEquals
EXEC sp_OAMethod @xml, 'TagUnpEquals', @success OUT, @unprefixedTag
Introduced in version 9.5.0.77

Returns 1 if this element's unprefixed tag exactly equals unprefixedTag; otherwise returns 0.

For example, the unprefixed tag of soapenv:Body is Body.

More Information and Examples
top
UnzipContent
EXEC sp_OAMethod @xml, 'UnzipContent', @success OUT

Reverses ZipContent: decodes and decompresses the calling element's compressed content and replaces the stored Base64-compressed representation with the original content.

Returns 1 on success and 0 on failure.

Returns 1 for success, 0 for failure.

More Information and Examples
top
UnzipTree
EXEC sp_OAMethod @xml, 'UnzipTree', @success OUT

Reverses ZipTree: decompresses the stored representation and reconstructs the calling element's previously compressed subtree.

The element's tag and attributes, which are not replaced by ZipTree, remain associated with the restored tree.

Returns 1 on success and 0 on failure.

Returns 1 for success, 0 for failure.

More Information and Examples
top
UpdateAt
EXEC sp_OAMethod @xml, 'UpdateAt', @success OUT, @tagPath, @autoCreate, @value
Introduced in version 9.5.0.64

Sets the text content of the element selected by tagPath to value.

If autoCreate is 1, missing elements along the path are created as needed. If it is 0, the update requires the target path to already exist.

Tag paths: A tag path is Chilkat's |-separated child-navigation syntax, for example tagA|tagB|tagC. It is not XPath.

More Information and Examples
top
UpdateAttrAt
EXEC sp_OAMethod @xml, 'UpdateAttrAt', @success OUT, @tagPath, @autoCreate, @attrName, @attrValue
Introduced in version 9.5.0.64

Sets attribute attrName to attrValue on the element selected by tagPath. The attribute is added when it does not already exist.

If autoCreate is 1, missing elements along the path are created as needed. If it is 0, the target path must already exist.

Tag paths: A tag path is Chilkat's |-separated child-navigation syntax, for example tagA|tagB|tagC. It is not XPath.

top
UpdateAttribute
EXEC sp_OAMethod @xml, 'UpdateAttribute', @success OUT, @attrName, @attrValue

Sets attribute attrName to attrValue. If the attribute already exists its value is replaced; otherwise the attribute is added.

Returns 1 on success and 0 on failure.

Returns 1 for success, 0 for failure.

More Information and Examples
top
UpdateAttributeInt
EXEC sp_OAMethod @xml, 'UpdateAttributeInt', @success OUT, @attrName, @value

Sets attribute attrName to the decimal representation of integer value. Use UpdateAttribute for string values.

Returns 1 on success and 0 on failure.

Returns 1 for success, 0 for failure.

top
UpdateChildContent
EXEC sp_OAMethod @xml, 'UpdateChildContent', NULL, @tagPath, @value

Sets the text content of the child selected by tagPath to value. Missing elements along the path are automatically created as needed.

Tag paths: A tag path is Chilkat's |-separated child-navigation syntax, for example tagA|tagB|tagC. It is not XPath.

top
UpdateChildContentInt
EXEC sp_OAMethod @xml, 'UpdateChildContentInt', NULL, @tagPath, @value

Sets the content of the child selected by tagPath to the decimal representation of integer value.

Tag paths: A tag path is Chilkat's |-separated child-navigation syntax, for example tagA|tagB|tagC. It is not XPath.

top
ZipContent
EXEC sp_OAMethod @xml, 'ZipContent', @success OUT

ZIP-compresses this element's text content and replaces the original content with Base64-encoded compressed data.

Returns 1 on success and 0 on failure.

Reversible transformation: Call UnzipContent to restore the original content.

Returns 1 for success, 0 for failure.

More Information and Examples
top
ZipTree
EXEC sp_OAMethod @xml, 'ZipTree', @success OUT

ZIP-compresses the calling element's content together with its entire child subtree and replaces that structure with Base64-encoded compressed data.

The calling element's tag and attributes are not changed. Call UnzipTree to reconstruct the compressed subtree.

Returns 1 on success and 0 on failure.

Returns 1 for success, 0 for failure.

More Information and Examples
top