example-retrieving-product-model-information-as-xml.md

title	Example: Retrieving Product Model Information as XML
description	View an example of how to retrieve product model information as XML by using RAW mode with 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	conceptual
ms.custom	ignite-2025
helpviewer_keywords	RAW mode, retrieving XML information example

Example: Retrieve product model information as XML

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

The following query returns product model information. RAW mode is specified in the FOR XML clause.

Example

USE AdventureWorks2022;
GO
SELECT ProductModelID, Name
FROM Production.ProductModel
WHERE ProductModelID IN (122, 119)
FOR XML RAW;
GO

This is the partial result:

<row ProductModelID="122" Name="All-Purpose Bike Stand" />
<row ProductModelID="119" Name="Bike Wash" />

You can retrieve element-centric XML by specifying the ELEMENTS directive.

USE AdventureWorks2022;
GO
SELECT ProductModelID, Name
FROM Production.ProductModel
WHERE ProductModelID IN (122, 119)
FOR XML RAW, ELEMENTS;
GO

This is the result:

<row>
  <ProductModelID>122</ProductModelID>
  <Name>All-Purpose Bike Stand</Name>
</row>
<row>
  <ProductModelID>119</ProductModelID>
  <Name>Bike Wash</Name>
</row>

You can optionally specify the TYPE directive to retrieve the results as xml type. The TYPE directive doesn't change the content of the results. Only the data type of the results is affected.

USE AdventureWorks2022;
GO
SELECT ProductModelID, Name
FROM Production.ProductModel
WHERE ProductModelID IN (122, 119)
FOR XML RAW, TYPE;
GO

See also

• Use RAW Mode with FOR XML