---
title: "Example: Specifying a Root Element for the XML Generated by 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: 
  - "RAW mode, specifying root element example"
  - "RAW mode, with FOR XML example"
ms.assetid: bcc54b11-0713-4e43-8dbe-d6f3ad1993b5
author: MightyPen
ms.author: genemi
manager: craigg
---
# Example: Specifying a Root Element for the XML Generated by FOR XML
  By specifying the `ROOT` option in the `FOR XML` query, you can request a single, top-level element for the resulting XML, as shown in this query. The argument specified for the `ROOT` directive provides the root element name.  
  
## Example  
  
```  
USE AdventureWorks2012;  
GO  
SELECT ProductModelID, Name   
FROM Production.ProductModel  
WHERE ProductModelID=122 or ProductModelID=119 or ProductModelID=115  
FOR XML RAW, ROOT('MyRoot')  
go  
```  
  
 This is the result:  
  
```  
<MyRoot>  
  <row ProductModelID="122" Name="All-Purpose Bike Stand" />  
  <row ProductModelID="119" Name="Bike Wash" />  
  <row ProductModelID="115" Name="Cable Lock" />  
</MyRoot>  
```  
  
## See Also  
 [Use RAW Mode with FOR XML](use-raw-mode-with-for-xml.md)