| title | Namespace Support in PATH Mode | Microsoft Docs | ||
|---|---|---|---|
| ms.custom | |||
| ms.date | 03/01/2017 | ||
| ms.prod | sql | ||
| ms.prod_service | database-engine | ||
| ms.reviewer | |||
| ms.technology | xml | ||
| ms.topic | conceptual | ||
| helpviewer_keywords |
|
||
| ms.assetid | 5f128ea2-0ceb-4b23-bce7-c8b3fd615466 | ||
| author | MightyPen | ||
| ms.author | genemi |
[!INCLUDEappliesto-ss-asdb-xxxx-xxx-md] Namespace support in the PATH mode is provided by using WITH NAMESPACES. For example, the following query demonstrates the WITH NAMESPACES syntax to declare a namespace ("a:") that can then be used in the subsequent SELECT statement:
WITH XMLNAMESPACES('a' as a)
SELECT 1 as 'a:b'
FOR XML PATH
These samples illustrate the use of PATH mode in generating XML from a SELECT query. Many of these queries are specified against the bicycle manufacturing instructions XML documents that are stored in the Instructions column of the ProductModel table.