Edit

Using Updategrams to Modify Data in SQLXML 4.0

  • Article

Applies to: SQL Server Azure SQL Database

You can modify (insert, update, or delete) a database in Microsoft SQL Server from an existing XML document by using an updategram or the OPENXML Transact-SQL function.

This section provides information about updategrams and examples of their usage.

In This Section

Introduction to Updategrams (SQLXML 4.0)
Provides basic information and examples of updategrams.

Specifying an Annotated Mapping Schema in an Updategram (SQLXML 4.0)
Explains and provides examples of annotated mapping schemas in updategrams.

NULL Handling (SQLXML 4.0)
Describes how to specify NULL for element and attribute values.

Inserting Data Using XML Updategrams (SQLXML 4.0)
Describes and provides examples of using updategrams to insert data.

Deleting Data Using XML Updategrams (SQLXML 4.0)
Describes and provides examples of using updategrams to delete data.

Updating Data Using XML Updategrams (SQLXML 4.0)
Describes and provides examples of using updategrams to modify existing data.

Passing Parameters to Updategrams (SQLXML 4.0)
Describes and provides examples of passing parameters to updategrams.

Handling Database Concurrency Issues in Updategrams (SQLXML 4.0)
Describes the various levels of protection possible for handling concurrency issues in updategrams, and provides examples.

Updategram Sample Applications (SQLXML 4.0)
Provides sample applications that use updategrams.

Guidelines and Limitations of XML Updategrams (SQLXML 4.0)
Lists some things to remember when working with updategrams.