--- title: "SQLXML 4.0 Programming Concepts" description: View information about the programming concepts used in SQLXML 4.0. author: MikeRayMSFT ms.author: mikeray ms.date: "03/06/2017" ms.prod: sql ms.prod_service: "database-engine, sql-database" ms.technology: xml ms.topic: "reference" helpviewer_keywords: - "SQLXML, about SQLXML" - "SQLXML" ms.assetid: 5a11cda2-b8a3-4453-848f-641afdaa7024 monikerRange: "=azuresqldb-current||>=sql-server-2016||>=sql-server-linux-2017||=azuresqldb-mi-current" --- # SQLXML 4.0 Programming Concepts [!INCLUDE [SQL Server Azure SQL Database Azure SQL Managed Instance](../../includes/applies-to-version/sql-asdb-asdbmi.md)] SQLXML 3.0 was offered as a Web release to provide additional client-side XML functionality and enhancements to existing features, such as annotated XSD schemas, XML bulk load, Web services (SOAP) support, and updategrams. [!INCLUDE[ssVersion2005](../../includes/ssversion2005-md.md)] introduced SQLXML 4.0, which continues to deliver the same functionality as SQLXML 3.0 plus additional updates provided to accommodate new features introduced with [!INCLUDE[ssVersion2005](../../includes/ssversion2005-md.md)]. This section provides information about SQLXML 4.0. [SQLXML Is Not Installed in SQL Server](../../relational-databases/sqlxml/sqlxml-is-not-installed-in-sql-server.md) Describes how to install SQLXML 4.0. [What's New in SQLXML 4.0 SP1](../../relational-databases/sqlxml/what-s-new-in-sqlxml-4-0-sp1.md) Describes the updates and enhancements in SQLXML 4.0, and provides links to relevant topics in this documentation. [Using ADO to Execute SQLXML 4.0 Queries](../../relational-databases/sqlxml/using-ado-to-execute-sqlxml-4-0-queries.md) Describes how to use ADO for SQLXML queries. ADO is more prominent in SQLXML 4.0 than in previous versions. [xml Data Type Support in SQLXML 4.0](../../relational-databases/sqlxml/xml-data-type-support-in-sqlxml-4-0.md) Describes the support for the xml data type that has been added for SQLXML 4.0. [Requirements for Running SQLXML Examples](../../relational-databases/sqlxml/requirements-for-running-sqlxml-examples.md) Describe the requirements for creating working samples from the SQLXML examples provided. [Client-side and Server-side Formatting (SQLXML 4.0)](../../relational-databases/sqlxml/formatting/client-side-and-server-side-formatting-sqlxml-4-0.md) Provides information about and comparisons of client-side and server-side formatting, including the FOR XML command for constructing XML documents. [Annotated XSD Schemas in SQLXML 4.0](../../relational-databases/sqlxml/annotated-xsd-schemas/annotated-xsd-schemas-in-sqlxml-4-0.md) Provides information about using annotated XSD schemas in SQLXML 4.0. Also provides information about annotated XDR schemas for use in legacy applications. [Using XPath Queries in SQLXML 4.0](../../relational-databases/sqlxml-annotated-xsd-schemas-xpath-queries/using-xpath-queries-in-sqlxml-4-0.md) Describes how to use a subset of the XPath language to query the XML views created by an annotated XSD schema, and provides examples. [Using Updategrams to Modify Data in SQLXML 4.0](../../relational-databases/sqlxml-annotated-xsd-schemas-xpath-queries/updategrams/using-updategrams-to-modify-data-in-sqlxml-4-0.md) Provides information about updategrams, which modify data in a database by working against the XML views provided by XSD (or XDR) annotated schemas. [Performing Bulk Load of XML Data (SQLXML 4.0)](../../relational-databases/sqlxml-annotated-xsd-schemas-xpath-queries/bulk-load-xml/performing-bulk-load-of-xml-data-sqlxml-4-0.md) Describes how to bulk load XML in SQLXML 4.0. [SQLXML 4.0 Data Access Components](../../relational-databases/sqlxml-annotated-xsd-schemas-xpath-queries/data-access-components-provider/sqlxml-4-0-data-access-components-sqlxmloledb-provider.md) Documents the SQLXMLOLEDB Provider and provides links to other SQLXML 4.0 data access components. [SQLXML 4.0 .NET Framework Support](../sqlxml-annotated-xsd-schemas-xpath-queries/net-framework-classes/sqlxml-4-0-net-framework-support-managed-classes.md) Describes the SQLXML 4.0 support for the .NET Framework. [Caching Templates, XSL, and Schemas (SQLXML 4.0)](../../relational-databases/sqlxml-annotated-xsd-schemas-xpath-queries/caching-templates-xml-schemas/caching-templates-xsl-and-schemas-sqlxml-4-0.md) Describes the caching functionality provided in SQLXML to improve performance. [SQLXML 4.0 Security Considerations](../../relational-databases/sqlxml-annotated-xsd-schemas-xpath-queries/security/sqlxml-4-0-security-considerations.md) Discusses security issues relevant to SQLXML 4.0. [Guidelines and Limitations of SQLXML 4.0](../../relational-databases/sqlxml-annotated-xsd-schemas-xpath-queries/guidelines-and-limitations-of-sqlxml-4-0.md) Lists issues to remember when working with SQLXML 4.0. ## See Also [XML Data (SQL Server)](../../relational-databases/xml/xml-data-sql-server.md)