Using Updategrams to Modify Data in SQLXML 4.0

You can modify (insert, update, or delete) a database in Microsoft SQL Server 2005 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.