Skip to content

Latest commit

 

History

History
76 lines (56 loc) · 4.8 KB

File metadata and controls

76 lines (56 loc) · 4.8 KB
title SQLXML 4.0 Programming Concepts | Microsoft Docs
ms.custom
ms.date 03/06/2017
ms.prod sql-server-2016
ms.reviewer
ms.suite
ms.technology
dbe-xml
ms.tgt_pltfrm
ms.topic reference
helpviewer_keywords
SQLXML, about SQLXML
SQLXML
ms.assetid 5a11cda2-b8a3-4453-848f-641afdaa7024
caps.latest.revision 38
author douglaslMS
ms.author douglasl
manager jhubbard

SQLXML 4.0 Programming Concepts

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.

[!INCLUDEssVersion2005] 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 [!INCLUDEssVersion2005].

This section provides information about SQLXML 4.0.

SQLXML Is Not Installed in SQL Server
Describes how to install SQLXML 4.0.

What's New in SQLXML 4.0 SP1
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
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
Describes the support for the xml data type that has been added for SQLXML 4.0.

Requirements for Running SQLXML Examples
Describe the requirements for creating working samples from the SQLXML examples provided.

Client-side and Server-side Formatting (SQLXML 4.0)
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
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
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
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)
Describes how to bulk load XML in SQLXML 4.0.

SQLXML 4.0 Data Access Components
Documents the SQLXMLOLEDB Provider and provides links to other SQLXML 4.0 data access components.

SQLXML 4.0 .NET Framework Support
Describes the SQLXML 4.0 support for the .NET Framework.

Caching Templates, XSL, and Schemas (SQLXML 4.0)
Describes the caching functionality provided in SQLXML to improve performance.

SQLXML 4.0 Security Considerations
Discusses security issues relevant to SQLXML 4.0.

Guidelines and Limitations of SQLXML 4.0
Lists issues to remember when working with SQLXML 4.0.

See Also

XML Data (SQL Server)