Skip to content

using-updategrams-to-modify-data-in-sqlxml-4-0.md

Latest commit

 

History

History
68 lines (55 loc) · 3.89 KB

using-updategrams-to-modify-data-in-sqlxml-4-0.md

File metadata and controls

68 lines (55 loc) · 3.89 KB
title Using Updategrams to Modify Data in SQLXML 4.0 | Microsoft Docs
ms.custom
ms.date 03/17/2017
ms.prod sql-server-2016
ms.reviewer
ms.suite
ms.technology
dbe-xml
ms.tgt_pltfrm
ms.topic reference
helpviewer_keywords
SQLXML, updategrams
data insertions [SQLXML]
data deletions [SQLXML]
updating data [SQLXML]
modifying data [SQLXML]
OPENXML function
updategrams [SQLXML]
database modifications [SQLXML]
data updates [SQLXML]
modifying databases
data modifications [SQLXML]
deleting data
inserting data
ms.assetid b8b3b892-cb73-41d0-b945-bce148d81d9b
caps.latest.revision 26
author douglaslMS
ms.author douglasl
manager jhubbard

Using Updategrams to Modify Data in SQLXML 4.0

You can modify (insert, update, or delete) a database in [!INCLUDEmsCoName] [!INCLUDEssNoVersion] from an existing XML document by using an updategram or the OPENXML [!INCLUDEtsql] 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.