इसके माध्यम से साझा किया गया


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.

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)

Help and Information

Getting SQL Server 2005 Assistance