Examples of large-capacity Import and Export of XML documents

Example Table

To test example A, you must create the example Table T.

Use tempdbcreate table t (intcol int, xmlcol XML); go

Sample Data File

Before running example A, you must create a UTF-8 encoding file (C: \ samplefolder \ sampledata3.txt) that contains the following example instance that specifies the UTF-8 encoding scheme.

<? XML version = "1.0" encoding = "UTF-8"?> <Root> <productdescription productmodelid = "5"> <summary> some text </Summary> </productdescription> </root>

Example

This example uses insert... select * From OpenRowSet (bulk ...) the single_blob option in the statement imports data from a file named sampledata3.txt and inserts an XML instance into the example table t that contains a single column.

Insert into T (xmlcol) Select * From OpenRowSet (bulk 'C: \ samplefolder \ sampledata3.txt ', single_blob) as X;

Examples of large-capacity Import and Export of XML documents