| 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.prod | sql | |||||||
| ms.prod_service | database-engine, sql-database | |||||||
| ms.technology | xml | |||||||
| ms.topic | reference | |||||||
| ms.custom | seo-lt-2019 | |||||||
| helpviewer_keywords |
|
|||||||
| ms.assetid | 3708b493-322e-4f3c-9b27-441d0c0ee346 | |||||||
| monikerRange | =azuresqldb-current||>=sql-server-2016||>=sql-server-linux-2017||=azuresqldb-mi-current |
[!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.
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.