Skip to content

specifying-a-node-test-in-the-location-path-sqlxml-4-0.md

Latest commit

 

History

History
50 lines (36 loc) · 2.83 KB

specifying-a-node-test-in-the-location-path-sqlxml-4-0.md

File metadata and controls

50 lines (36 loc) · 2.83 KB
title Specifying a Node Test in the Location Path (SQLXML)
description Learn how to specify a node test in the location path of an SQLXML 4.0 XPath query.
author MikeRayMSFT
ms.author mikeray
ms.date 03/16/2017
ms.service sql
ms.subservice xml
ms.topic reference
helpviewer_keywords
XPath queries [SQLXML], location paths
principal node types [SQLXML]
node tests [SQLXML]
location path for XPath query
monikerRange =azuresqldb-current||>=sql-server-2016||>=sql-server-linux-2017||=azuresqldb-mi-current

Specifying a Node Test in the Location Path (SQLXML 4.0)

[!INCLUDE SQL Server Azure SQL Database] A node test specifies the node type selected by the location step. Every axis (child, parent, attribute, or self) has a principal node type. For the attribute axis, the principal node type is <attribute>. For the parent, child, and self axes, the principal node type is <element>.

Note

The wildcard node test * (for example, child::*) is not supported.

Node Test: Example 1

The location path child::Customer selects <Customer> element children of the context node.

In this example, child is the axis and Customer is the node test. The principal node type for the child axis is <element>. Therefore, the node test is TRUE if the <Customer> node is an <element> node. If the context node has no <Customer> children, an empty set of nodes is returned.

Node Test: Example 2

The location path attribute::CustomerID selects the CustomerID attribute of the context node.

In the example, attribute is the axis and CustomerID is the node test. The principal node type of the attribute axis is <attribute>. Therefore, the node test is TRUE if CustomerID is an <attribute> node. If the context node has no CustomerID, an empty set of nodes is returned.

Note

In this implementation of XPath, if a location step refers to an <element> or an <attribute> type that is not declared in the schema, an error is generated. This is different from the implementation of XPath in MSXML, which returns an empty node set.

Abbreviated Syntax for the Axes

The following abbreviated syntax for the location path is supported:

  • attribute:: can be abbreviated to @.

    The location path Customer[@CustomerID="ALFKI"] is the same as child::Customer[attribute::CustomerID="ALFKI"].

  • child:: can be omitted from a location step.

    Thus, child is the default axis. The location path Customer/Order is the same as child::Customer/child::Order.

  • self::node() can be abbreviated to one period (.), and parent::node() can be abbreviated to two periods (..).