Skip to content

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

Latest commit

 

History

History
57 lines (42 loc) · 3.37 KB

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

File metadata and controls

57 lines (42 loc) · 3.37 KB
title Use RAW Mode with FOR XML | Microsoft Docs
ms.date 03/04/2017
ms.prod sql
ms.prod_service database-engine
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
ms.custom seo-lt-2019

Use RAW Mode with FOR XML

[!INCLUDEappliesto-ss-asdb-xxxx-xxx-md]

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)