annotation-interpretation-other-annotations.md

title	Other Annotations (SQLXML 4.0) | Microsoft Docs
ms.custom
ms.date	03/14/2017
ms.prod	sql-server-2016
ms.reviewer
ms.suite
ms.technology	dbe-xml
ms.tgt_pltfrm
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
caps.latest.revision	20
author	douglaslMS
ms.author	douglasl
manager	jhubbard

Annotation Interpretation - Other Annotations

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)