Search This Blog

SQL server 2008 : SQLXML XPATH LIMITATIONS

SQLXML supports a subset of XPath queries. Following is a list of limitations imposed on the SQLXML XPath implementation:

• The only axis specifiers supported are child, parent, attribute, and self.
• Only element and attribute node types are supported.
• Only predicates that return a boolean result are supported. Numeric predicates like [1] are not supported.
• Only the three XPath data types are supported: string, number, and boolean.
• SQLXML 4 does not support the root query (specified by a forward slash /), or descendant-or-self queries (specified by double slashes //). Every query must begin at a top-level schema element type.
• SQLXML does not support queries that generate a Cartesian product.
• The mod and union (|) operators, string functions, and numeric functions are not supported.