Specifying an Axis (SQLXML 4.0)

Applies to: SQL Server Azure SQL Database

• The axis specifies the tree relationship between the nodes selected by the location step and the context node. The following axes are supported: child

  Contains the child of the context node.

  The following XPath expression (location path) selects from the current context node all the <Customer> children:

  child::Customer  
  

  In the following XPath query, child is the axis. Customer is the node test.

• parent

  Contains the parent of the context node.

  The following XPath expression selects all the <Customer> parents of the <Order> children:

  child::Customer/child::Order[parent::Customer/@customerID="ALFKI"]  
  

  This is the same as specifying child::Customer. In this XPath query, child and parent are the axes. Customer and Order are the node tests.

• attribute

  Contains the attribute of the context node.

  The following XPath expression selects the CustomerID attribute of the context node:

  attribute::CustomerID  
  

• self

  Contains the context node itself.

  The following XPath expression selects the current node if it is the <Order> node:

  self::Order  
  

  In this XPath query, self is the axis and Order is the node test.