Skip to content

example-renaming-the-row-element.md

Latest commit

 

History

History
44 lines (35 loc) · 1.34 KB

example-renaming-the-row-element.md

File metadata and controls

44 lines (35 loc) · 1.34 KB
title Example: Renaming the <row> Element
description View an example of renaming an XML row element by specifying an optional argument to RAW mode in the FOR XML clause.
author MikeRayMSFT
ms.author mikeray
ms.reviewer randolphwest
ms.date 05/05/2022
ms.service sql
ms.subservice xml
ms.topic how-to
ms.custom
ignite-2025
helpviewer_keywords
RAW mode, renaming <row> example

Example: Rename the <row> element

[!INCLUDE SQL Server Azure SQL Database Azure SQL Managed Instance FabricSQLDB]

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