Export (0) Print
Expand All
This topic has not yet been rated - Rate this topic

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.

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.

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.