Skip to content

specifying-an-axis-sqlxml-4-0.md

Latest commit

 

History

History
82 lines (61 loc) · 2.4 KB

specifying-an-axis-sqlxml-4-0.md

File metadata and controls

82 lines (61 loc) · 2.4 KB

title: "Specifying an Axis (SQLXML 4.0) | Microsoft Docs" ms.custom: "" ms.date: "03/04/2017" ms.prod: "sql" ms.prod_service: "database-engine, sql-database" ms.service: "" ms.component: "sqlxml" ms.reviewer: "" ms.suite: "sql" ms.technology:

  • "dbe-xml" ms.tgt_pltfrm: "" ms.topic: "reference" helpviewer_keywords:
  • "XPath queries [SQLXML], axes"
  • "XPath queries [SQLXML], location paths"
  • "self axis"
  • "attribute axis [SQLXML]"
  • "axis [SQLXML]"
  • "child axis"
  • "parent axis"
  • "location path for XPath query"
  • "axes [SQLXML]" ms.assetid: 65631795-3389-40cf-90ea-85e9438956c5 caps.latest.revision: 22 author: "douglaslMS" ms.author: "douglasl" manager: "craigg" ms.workload: "Inactive" monikerRange: "= azuresqldb-current || >= sql-server-2016 || = sqlallproducts-allversions"

Specifying an Axis (SQLXML 4.0)

[!INCLUDEappliesto-ss-asdb-xxxx-xxx-md]

  • 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.