xml Data Type Methods
The following table lists the xml data type methods.
In This Section
| Topic | Description |
|---|---|
Use this method to query over an XML instance. |
|
Use this method to retrieve a value of SQL type from an XML instance. |
|
Use this method to determine whether a query returns a nonempty result. |
|
Use this method to specify XML DML statements to perform updates. |
|
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
Note
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.
See Also
Concepts
Typed vs. Untyped XML
Generating XML Instances
XML Data Modification Language (XML DML)
Binding Relational Data Inside XML Data
xml Data Type
Sample XML Applications