Sample XPath Queries (SQLXML 4.0)
Applies to: 
SQL Server
Azure SQL Database
This section provides examples of XPath queries for SQLXML 4.0. For illustration purposes, these example XPath queries are specified in a template executed using ADO. Therefore, you must use a mapping schema file, SampleSchema1.xml, which is also provided in this section. Save this file in the directory where your templates are stored.
Note
The sample queries in this section are grouped by the type of XPath operation that is performed by the query.
In This Section
Sample Annotated XSD Schema for XPath Examples (SQLXML 4.0)
Use this file with the XPath query examples provided in this section.
Specifying Axes in XPath Queries (SQLXML 4.0)
Illustrates how axes are specified in XPath queries.
Specifying Boolean-Valued Predicates in XPath Queries (SQLXML 4.0)
Illustrates how Boolean-valued predicates are specified in XPath queries.
Specifying Relational Operators in XPath Queries (SQLXML 4.0)
Illustrates how relational operators are specified in XPath queries.
Specifying Arithmetic Operators in XPath Queries (SQLXML 4.0)
Illustrates how arithmetic operators are specified in XPath queries.
Specifying Explicit Conversion Functions in XPath Queries (SQLXML 4.0)
Illustrates how explicit conversion functions are specified in XPath queries.
Specifying Boolean Operators in XPath Queries (SQLXML 4.0)
Illustrates how Boolean operators are specified in XPath queries.
Specifying Boolean Functions in XPath Queries (SQLXML 4.0)
Illustrates how Boolean functions are specified in XPath queries.
Specifying XPath Variables in XPath Queries (SQLXML 4.0)
Illustrates how XPath variables are specified in XPath queries.