| title | description | author | ms.author | ms.reviewer | ms.date | ms.service | ms.subservice | ms.topic | helpviewer_keywords | ||
|---|---|---|---|---|---|---|---|---|---|---|---|
XML data (SQL Server) |
Use XML data for developing rich applications for semi-structured data management. |
MikeRayMSFT |
mikeray |
randolphwest |
08/04/2023 |
sql |
xml |
conceptual |
|
[!INCLUDE SQL Server Azure SQL Database]
[!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].