Skip to content

example-specifying-a-root-element-for-the-xml-generated-by-for-xml.md

Latest commit

 

History

History
45 lines (38 loc) · 1.24 KB

example-specifying-a-root-element-for-the-xml-generated-by-for-xml.md

File metadata and controls

45 lines (38 loc) · 1.24 KB
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