Skip to content

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

Latest commit

 

History

History
59 lines (48 loc) · 3.78 KB

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

File metadata and controls

59 lines (48 loc) · 3.78 KB
title Using Updategrams to Modify Data in SQLXML 4.0
description View information and examples about updategrams and how they are used for modifying data in SQLXML 4.0.
author MikeRayMSFT
ms.author mikeray
ms.date 03/17/2017
ms.service sql
ms.subservice xml
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
monikerRange =azuresqldb-current||>=sql-server-2016||>=sql-server-linux-2017||=azuresqldb-mi-current

Using Updategrams to Modify Data in SQLXML 4.0

[!INCLUDE SQL Server Azure SQL Database] 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.

Guidelines and Limitations of XML Updategrams (SQLXML 4.0)
Lists some things to remember when working with updategrams.