---
title: "Use PATH Mode with FOR XML | Microsoft Docs"
ms.custom: ""
ms.date: "06/13/2017"
ms.prod: "sql-server-2014"
ms.reviewer: ""
ms.technology: xml
ms.topic: conceptual
helpviewer_keywords: 
  - "PATH FOR XML mode"
  - "characters [SQL Server], XML"
  - "aliases [SQL Server], XML"
  - "FOR XML clause, PATH mode"
  - "FOR XML PATH mode"
  - "column names [SQL Server]"
  - "XPath queries [SQL Server]"
ms.assetid: a685a9ad-3d28-4596-aa72-119202df3976
author: MightyPen
ms.author: genemi
manager: craigg
---
# Use PATH Mode with FOR XML
  As described in [Constructing XML Using FOR XML](for-xml-sql-server.md), the PATH mode provides a simpler way to mix elements and attributes. PATH mode is also a simpler way to introduce additional nesting for representing complex properties. You can use FOR XML EXPLICIT mode queries to construct such XML from a rowset, but the PATH mode provides a simpler alternative to the potentially cumbersome EXPLICIT mode queries. PATH mode, together with the ability to write nested FOR XML queries and the TYPE directive to return **xml** type instances, allows you to write queries with less complexity.  
  
 In PATH mode, column names or column aliases are treated as XPath expressions. These expressions indicate how the values are being mapped to XML. Each XPath expression is a relative XPath that provides the item type., such as the attribute, element, and scalar value, and the name and hierarchy of the node that will be generated relative to the row element.  
  
 This section describes mapping columns in a rowset under various conditions, and provides examples.  
  
## In This Section  
  
-   [Columns without a Name](columns-without-a-name.md)  
  
-   [Columns with a Name](columns-with-a-name.md)  
  
-   [Columns with a Name Specified as a Wildcard Character](columns-with-a-name-specified-as-a-wildcard-character.md)  
  
-   [Columns with the Name of an XPath Node Test](columns-with-the-name-of-an-xpath-node-test.md)  
  
-   [Column Names with the Path Specified as data()](column-names-with-the-path-specified-as-data.md)  
  
-   [Columns that Contain a Null Value By Default](columns-that-contain-a-null-value-by-default.md)  
  
-   [Namespace Support in PATH Mode](namespace-support-in-path-mode.md)  
  
-   [Examples: Using PATH Mode](examples-using-path-mode.md)  
  
## See Also  
 [Add Namespaces to Queries with WITH XMLNAMESPACES](add-namespaces-to-queries-with-with-xmlnamespaces.md)   
 [SELECT (Transact-SQL)](/sql/t-sql/queries/select-transact-sql)   
 [FOR XML (SQL Server)](for-xml-sql-server.md)