Skip to content

xml-data-sql-server.md

Latest commit

 

History

History
48 lines (35 loc) · 2.65 KB

xml-data-sql-server.md

File metadata and controls

48 lines (35 loc) · 2.65 KB
title XML data (SQL Server)
description Use XML data for developing rich applications for semi-structured data management.
author MikeRayMSFT
ms.author mikeray
ms.reviewer randolphwest
ms.date 08/04/2023
ms.service sql
ms.subservice xml
ms.topic conceptual
ms.custom
ignite-2025
helpviewer_keywords
XML [SQL Server]
XML [SQL Server], about XML

XML data (SQL Server)

[!INCLUDE SQL Server Azure SQL Database FabricSQLDB]

[!INCLUDEssNoVersion] provides a powerful platform for developing rich applications for semi-structured data management. Support for XML is integrated into all the components in [!INCLUDEssNoVersion] in the following ways:

  • The xml data type. XML values can be stored natively in an xml data type column that can be typed according to a collection of XML schemas, or left untyped. You can index the XML column.

  • The ability to specify an XQuery query against XML data stored in columns and variables of the xml type.

  • Enhancements to OPENROWSET to allow bulk loading of XML data.

  • The FOR XML clause, to retrieve relational data in XML format.

  • The OPENXML function, to retrieve XML data in relational format.

  • XML compression provides a method to compress off-row XML data for both XML columns and indexes, improving capacity requirements. For more information, see CREATE TABLE (Transact-SQL) and CREATE INDEX (Transact-SQL). XML compression is available in [!INCLUDEsssql22-md] and later versions, [!INCLUDE ssazure-sqldb], and [!INCLUDE ssazuremi].

Next steps

See also