Export (0) Print
Expand All

Other Annotations (SQLXML 4.0)

In addition to the annotations discussed in the previous topics in this section, XML Bulk Load interprets these other annotations, as follows:

sql:id-prefix

If the schema specifies prefixes to the XML data, XML Bulk Load removes the prefixes before sending the data to Microsoft SQL Server.

sql:use-cdata

XML Bulk Load reads the text that is stored in the CDATA sections and sends it to SQL Server.

sql:url-encode

XML Bulk Load does not support this annotation. For example, you cannot specify a URL in the XML data input and expect XML Bulk Load to read data from that location to store it in the database.

sql:is-mapping-schema

XML Bulk Load does not support this annotation, nor does it support sql:id.

NoteNote

XML Bulk Load does not support inline mapping schemas.

sql:key-fields

XML Bulk Load always ignores this annotation.

Community Additions

ADD
Show:
© 2015 Microsoft