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:
If the schema specifies prefixes to the XML data, XML Bulk Load removes the prefixes before sending the data to Microsoft SQL Server.
XML Bulk Load reads the text that is stored in the CDATA sections and sends it to SQL Server.
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.
XML Bulk Load does not support this annotation, nor does it support sql:id.
XML Bulk Load does not support inline mapping schemas.
XML Bulk Load always ignores this annotation.