Mapping XSD Data Types to XPath Data Types (SQLXML 4.0)
Applies to: 
SQL Server
Azure SQL Database
When an XPath query is executed against an XSD schema and the XSD type is specified in the xsd:type attribute, XPath uses the data type specified when it processes the query.
The XPath data type of a node is derived from the XSD data type in the schema, as shown in the following table. (The EmployeeID node is used for the purpose of illustration.)
| XSD data type | XDR data type | Equivalent XPath data type |
SQL Server conversion that is used |
|---|---|---|---|
| Base64Binary HexBinary |
None bin.base64bin.hex |
Not applicable | None EmployeeID |
| Boolean | boolean | boolean | CONVERT(bit, EmployeeID) |
| Decimal, integer, float, byte, short, int, long, float, double, unsignedByte, unsignedShort, unsignedInt, unsignedLong | number, int, float,i1, i2, i4, i8,r4, r8ui1, ui2, ui4, ui8 | number | CONVERT(float(53), EmployeeID) |
| id, idref, idrefsentity, entities, notation, nmtoken, nmtokens, DateTime, string, AnyURI | id, idref, idrefsentity, entities, enumeration, notation, nmtoken, nmtokens, char, dateTime, dateTime.tz, string, uri, uuid | string | CONVERT(nvarchar(4000), EmployeeID, 126) |
| decimal | fixed14.4 | Not applicable (There is no data type in XPath that is equivalent to the fixed14.4 XDR data type.) | CONVERT(money, EmployeeID) |
| date | date | string | LEFT(CONVERT(nvarchar(4000), EmployeeID, 126), 10) |
| time | time time.tz |
string | SUBSTRING(CONVERT(nvarchar(4000), EmployeeID, 126), 1 + CHARINDEX(N'T', CONVERT(nvarchar(4000), EmployeeID, 126)), 24) |