---
title: "Using Updategrams to Modify Data in SQLXML 4.0 | Microsoft Docs"
ms.custom: ""
ms.date: "03/08/2017"
ms.prod: "sql-server-2014"
ms.reviewer: ""
ms.technology: 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"
ms.assetid: b8b3b892-cb73-41d0-b945-bce148d81d9b
author: MightyPen
ms.author: genemi
manager: craigg
---
# Using Updategrams to Modify Data in SQLXML 4.0
  You can modify (insert, update, or delete) a database in [!INCLUDE[msCoName](../../../includes/msconame-md.md)] [!INCLUDE[ssNoVersion](../../../includes/ssnoversion-md.md)] from an existing XML document by using an updategram or the OPENXML [!INCLUDE[tsql](../../../includes/tsql-md.md)] function.  
  
 This section provides information about updategrams and examples of their usage.  
  
## In This Section  
 [Introduction to Updategrams (SQLXML 4.0)](introduction-to-updategrams-sqlxml-4-0.md)  
 Provides basic information and examples of updategrams.  
  
 [Specifying an Annotated Mapping Schema in an Updategram (SQLXML 4.0)](specifying-an-annotated-mapping-schema-in-an-updategram-sqlxml-4-0.md)  
 Explains and provides examples of annotated mapping schemas in updategrams.  
  
 [NULL Handling (SQLXML 4.0)](null-handling-sqlxml-4-0.md)  
 Describes how to specify NULL for element and attribute values.  
  
 [Inserting Data Using XML Updategrams (SQLXML 4.0)](inserting-data-using-xml-updategrams-sqlxml-4-0.md)  
 Describes and provides examples of using updategrams to insert data.  
  
 [Deleting Data Using XML Updategrams (SQLXML 4.0)](deleting-data-using-xml-updategrams-sqlxml-4-0.md)  
 Describes and provides examples of using updategrams to delete data.  
  
 [Updating Data Using XML Updategrams (SQLXML 4.0)](updating-data-using-xml-updategrams-sqlxml-4-0.md)  
 Describes and provides examples of using updategrams to modify existing data.  
  
 [Passing Parameters to Updategrams (SQLXML 4.0)](passing-parameters-to-updategrams-sqlxml-4-0.md)  
 Describes and provides examples of passing parameters to updategrams.  
  
 [Handling Database Concurrency Issues in Updategrams (SQLXML 4.0)](handling-database-concurrency-issues-in-updategrams-sqlxml-4-0.md)  
 Describes the various levels of protection possible for handling concurrency issues in updategrams, and provides examples.  
  
 [Updategram Sample Applications (SQLXML 4.0)](../../../database-engine/dev-guide/updategram-sample-applications-sqlxml-4-0.md)  
 Provides sample applications that use updategrams.  
  
 [Guidelines and Limitations of XML Updategrams (SQLXML 4.0)](guidelines-and-limitations-of-xml-updategrams-sqlxml-4-0.md)  
 Lists some things to remember when working with updategrams.