Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
V0100:
The specification states the following:
-
Subclause 12.8, "<SQL-invoked routine>": Without Feature X110, "Host language support for XML: VARCHAR mapping", conforming SQL language shall not contain a <string type option> that contains CHARACTER VARYING, CHAR VARYING, or VARCHAR. Subclause 18.3, "<embedded SQL C program>": Without Feature X110, "Host language support for XML: VARCHAR mapping", conforming SQL language shall not contain an <C XML VARCHAR variable>. Subclause 18.7, "<embedded SQL PL/I program>": Without Feature X110, "Host language support for XML: VARCHAR mapping", conforming SQL language shall not contain an <PL/I XML VARCHAR variable>.
Microsoft SQL Server 2008 R2 and Microsoft SQL Server 2012 vary as follows:
Transact-SQL partially supports this feature. PL/I and C language support is not available.
This variation pertains to xml data type functionality in SQL Server.