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.