server-side-xml-formatting-sqlxml-4-0.md

title	Server-side XML Formatting (SQLXML 4.0) | Microsoft Docs
ms.custom
ms.date	03/14/2017
ms.prod	sql
ms.prod_service	database-engine, sql-database
ms.component	sqlxml
ms.reviewer
ms.suite	sql
ms.technology	xml
ms.tgt_pltfrm
ms.topic	reference
helpviewer_keywords	FOR XML clause, formatting server-side XML formatting
ms.assetid	ae9ea068-0857-4505-a3b2-f53d256b644c
caps.latest.revision	12
author	douglaslMS
ms.author	douglasl
manager	craigg
monikerRange	=azuresqldb-current||>=sql-server-2016||=sqlallproducts-allversions||>=sql-server-linux-2017||=azuresqldb-mi-current

Server-side XML Formatting (SQLXML 4.0)

[!INCLUDEappliesto-ss-asdb-xxxx-xxx-md] This topic provides information about formatting XML documents on the server side from the rowsets that are generated by queries executed against a database in Microsoft [!INCLUDEssNoVersion].

In [!INCLUDEssNoVersion], you can store and retrieve XML documents to and from database tables. To retrieve an XML document, use the FOR XML query extension in a SELECT query.

For example, assume a client application executes a command against [!INCLUDEssNoVersion] that consists of the following [!INCLUDEtsql] query:

SELECT FirstName, LastName  
FROM   Person.Contact  
FOR XML AUTO  

The server executes the query in two steps. First, the server executes this SELECT statement:

SELECT FirstName, LastName  
FROM   Person.Contact  

Then the server applies the FOR XML transformation to the generated rowset. The resulting XML is then sent to the client as a one-column rowset. In this documentation, this process is referred to as server-side XML formatting.

On the server side, you can specify the following modes with a FOR XML clause:

• RAW

• AUTO

• EXPLICIT

For more information about the FOR XML clause, see Constructing XML Using FOR XML.

See Also

Architecture of Client-side and Server-side XML Formatting (SQLXML 4.0)
Client-side XML Formatting (SQLXML 4.0)
FOR XML (SQL Server)