Skip to content

Latest commit

 

History

History
46 lines (37 loc) · 2.89 KB

File metadata and controls

46 lines (37 loc) · 2.89 KB
title Performing Bulk Load of XML Data (SQLXML)
description Learn how to use XML Bulk Load in SQLXML 4.0 to load semi-structured XML data into Microsoft SQL Server tables.
author MikeRayMSFT
ms.author mikeray
ms.date 03/17/2017
ms.service sql
ms.subservice xml
ms.topic reference
helpviewer_keywords
XML Bulk Load [SQLXML]
bulk load [SQLXML]
data insertions [SQLXML]
SQLXML, bulk loading
XSD schemas [SQLXML], XML Bulk Load
XDR schemas [SQLXML], XML Bulk Load
inserting data
monikerRange =azuresqldb-current||>=sql-server-2016||>=sql-server-linux-2017||=azuresqldb-mi-current

Performing Bulk Load of XML Data (SQLXML 4.0)

[!INCLUDE SQL Server Azure SQL Database] XML Bulk Load is a standalone COM object that allows you to load semistructured XML data into Microsoft [!INCLUDEssNoVersion] tables.

In This Section

Introduction to XML Bulk Load (SQLXML 4.0)
Provides general information about bulk loading XML data with the XML Bulk Load utility. Topics include XML data streaming and transacted vs. nontransacted bulk load operations.

Record Generation Process (SQLXML 4.0)
Describes the process and rules by which records are generated for XML Bulk Load.

Annotation Interpretation (SQLXML 4.0)
Describes how XML Bulk Load interprets annotations in XSD and XDR schemas.

SQL Server XML Bulk Load Object Model (SQLXML 4.0)
Describes the SQLXMLBulkLoad object and its methods and properties.

XML Bulk Load Examples (SQLXML 4.0)
Provides example code that uses XML Bulk Load.

Data Types and XML Bulk Load Behavior (SQLXML 4.0)
Describes XML Bulk Load Behavior with different types in XSD and XDR.

Guidelines and Limitations of XML Bulk Load (SQLXML 4.0)
Lists some issues to be aware of when working with XML Bulk Load.