Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
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.
Note
XML Bulk Load does not support inline mapping schemas.
- sql:key-fields
XML Bulk Load always ignores this annotation.
See Also
Reference
Annotation Interpretation (SQLXML 4.0)