XQueries Handling Relational Data

You specify XQuery against an xml type column or variable by using one of the XML Data Type Methods. These include query(), value(), exist(), or modify(). The XQuery is executed against the XML instance identified in the query generating the XML.

The XML generated by the execution of an XQuery can include values retrieved from other Transact-SQL variable or rowset columns. To bind non-XML relational data to the resulting XML, SQL Server provides the following pseudo functions as XQuery extensions:

  • sql:column() function

  • sql:variable() function

You can use these XQuery extensions when specifying an XQuery in the query() method of the xml data type. As a result, the query() method can produce XML that combines data from XML and non-xml data types.

You can also use these functions when you use the xml data type methods modify(), value(), query(), and exist()to expose a relational value inside XML.

For more information, see sql:column() function (XQuery) and sql:variable() function (XQuery).

Community Additions