Skip to content

use-raw-mode-with-for-xml.md

Latest commit

 

History

History
54 lines (41 loc) · 2.95 KB

use-raw-mode-with-for-xml.md

File metadata and controls

54 lines (41 loc) · 2.95 KB
title Use RAW Mode with 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
FOR XML RAW mode
XMLSCHEMA option
FOR XML clause, RAW mode
RAW FOR XML mode
ELEMENTS directive
RAW mode
XMLDATA option
ms.assetid 02c1bc0b-760c-4589-9ab1-6927c6d9c734
author MightyPen
ms.author genemi
manager craigg

Use RAW Mode with FOR XML

RAW mode transforms each row in the query result set into an XML element that has the generic identifier <row>, or the optionally provided element name. By default, each column value in the rowset that is not NULL is mapped to an attribute of the <row> element. If the ELEMENTS directive is added to the FOR XML clause, each column value is mapped to a subelement of the <row> element. Together with the ELEMENTS directive, you can optionally specify the XSINIL option to map NULL column values in the result set to an element that has the attribute, xsi:nil="true".

You can request a schema for the resulting XML. Specifying the XMLDATA option returns an in-line XDR schema. Specifying the XMLSCHEMA option returns an in-line XSD schema. The schema appears at the start of the data. In the result, the schema namespace reference is repeated for every top-level element.

The BINARY BASE64 option must be specified in the FOR XML clause to return the binary data in base64-encoded format. In RAW mode, retrieving binary data without specifying the BINARY BASE64 option will result in an error.

In This Section

This section contains the following examples:

See Also

Add Namespaces to Queries with WITH XMLNAMESPACES
Use AUTO Mode with FOR XML
Use EXPLICIT Mode with FOR XML
Use PATH Mode with FOR XML
SELECT (Transact-SQL)
FOR XML (SQL Server)