Edit

Specifying an Axis (SQLXML 4.0)

  • Article

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.