example-renaming-the-row-element.md

title	Example: Renaming the <row> Element | 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	RAW mode, renaming <row> example
ms.assetid	b042292a-0b6e-40a3-b254-71c06e626706
author	MightyPen
ms.author	genemi

Example: Renaming the <row> Element

[!INCLUDEappliesto-ss-asdb-xxxx-xxx-md] For each row in the result set, the RAW mode generates an element <row>. You can optionally specify another name for this element by specifying an optional argument to the RAW mode, as shown in this query. The query returns a <ProductModel> element for each row in the rowset.

Example

SELECT ProductModelID, Name   
FROM Production.ProductModel  
WHERE ProductModelID=122  
FOR XML RAW ('ProductModel'), ELEMENTS  
GO  

This is the result. Because the ELEMENTS directive is added in the query, the result is element-centric.

<ProductModel>  
  <ProductModelID>122</ProductModelID>  
  <Name>All-Purpose Bike Stand</Name>  
</ProductModel>   

See Also

Use RAW Mode with FOR XML