Annotation Interpretation - Other Annotations
Applies to:
SQL Server
Azure SQL Database
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
Athugasemdir
https://aka.ms/ContentUserFeedback.
Væntanlegt: Á árinu 2024 munum við hætta með GitHub-mál sem ábendingaleið fyrir efni og skipta því út fyrir nýtt ábendingakerfi. Frekari upplýsingar er að finna hér:Senda inn og skoða endurgjöf fyrir