---
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 [!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)](../../../relational-databases/sqlxml-annotated-xsd-schemas-xpath-queries/updategrams/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)](../../../relational-databases/sqlxml-annotated-xsd-schemas-xpath-queries/updategrams/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)](../../../relational-databases/sqlxml-annotated-xsd-schemas-xpath-queries/updategrams/null-handling-sqlxml-4-0.md)  
 Describes how to specify NULL for element and attribute values.  
  
 [Inserting Data Using XML Updategrams (SQLXML 4.0)](../../../relational-databases/sqlxml-annotated-xsd-schemas-xpath-queries/updategrams/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)](../../../relational-databases/sqlxml-annotated-xsd-schemas-xpath-queries/updategrams/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)](../../../relational-databases/sqlxml-annotated-xsd-schemas-xpath-queries/updategrams/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)](../../../relational-databases/sqlxml-annotated-xsd-schemas-xpath-queries/updategrams/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)](../../../relational-databases/sqlxml-annotated-xsd-schemas-xpath-queries/updategrams/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)](http://msdn.microsoft.com/library/d2287e10-4007-4ba4-ad84-4e2b6adfede5)  
 Provides sample applications that use updategrams.  
  
 [Guidelines and Limitations of XML Updategrams (SQLXML 4.0)](../../../relational-databases/sqlxml-annotated-xsd-schemas-xpath-queries/updategrams/guidelines-and-limitations-of-xml-updategrams-sqlxml-4-0.md)  
 Lists some things to remember when working with updategrams.