Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
The following table lists the xml data type methods.
| 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.
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