Using Updategrams to Modify Data in SQLXML 4.0
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.
Feedback
https://aka.ms/ContentUserFeedback.
Kommer snart: I hele 2024 udfaser vi GitHub-problemer som feedbackmekanisme for indhold og erstatter det med et nyt feedbacksystem. Du kan få flere oplysninger under:Indsend og få vist feedback om