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.
-
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.