annotation-interpretation-other-annotations.md

title	Other Annotations (SQLXML 4.0) | Microsoft Docs
ms.custom
ms.date	03/06/2017
ms.prod	sql-server-2014
ms.reviewer
ms.technology	xml
ms.topic	reference
helpviewer_keywords	url-encode annotation sql:key-fields use-cdata annotation sql:is-mapping-schema sql:url-encode sql:id-prefix sql:use-cdata key-fields annotation id-prefix annotation [SQLXML] is-mapping-schema annotation
ms.assetid	f7b4d37b-d6d3-4ac3-b2fd-a0b534a924e4
author	MightyPen
ms.author	genemi
manager	craigg

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 [!INCLUDEssNoVersion].

sql:use-cdata
XML Bulk Load reads the text that is stored in the CDATA sections and sends it to [!INCLUDEssNoVersion].

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

Annotation Interpretation (SQLXML 4.0)