Example: Renaming the <row> Element

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.


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

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

  <Name>All-Purpose Bike Stand</Name>  

See Also

Use RAW Mode with FOR XML