Click to Rate and Give Feedback

  Switch on low bandwidth view
Community Content
In this section
Statistics Annotations (0)
SQL Server 2005 Books Online (November 2008)
xml Data Type Methods

The following table lists the xml data type methods.

Topic Description

query() Method (xml Data Type)

Use this method to query over an XML instance.

value() Method (xml Data Type)

Use this method to retrieve a value of SQL type from an XML instance.

exist() Method (xml Data Type)

Use this method to determine whether a query returns a nonempty result.

modify() Method (xml Data Type)

Use this method to specify XML DML statements to perform updates.

nodes() Method (xml Data Type)

Use this method to shred XML into multiple rows to propagate parts of XML documents into rowsets.

You call these methods by using the user-defined type method invocation syntax. For example:

SELECT XmlCol.query(' ... ')
FROM   Table
ms190798.note(en-US,SQL.90).gifNote:
The xml data type methods query(), value(), and exist() return NULL if executed against a NULL XML instance. Also, modify() does not return anything, but nodes() returns rowsets and an empty rowset with a NULL input.

Tags What's this?: xml (x) Add a tag
Community Content   What is Community Content?
Add new content RSS  Annotations
Processing
© 2009 Microsoft Corporation. All rights reserved. Terms of Use  |  Trademarks  |  Privacy Statement
Page view tracker