नोट
इस पृष्ठ तक पहुंच के लिए प्राधिकरण की आवश्यकता होती है। आप साइन इन करने या निर्देशिकाएँ बदलने का प्रयास कर सकते हैं।
इस पृष्ठ तक पहुंच के लिए प्राधिकरण की आवश्यकता होती है। आप निर्देशिकाएँ बदलने का प्रयास कर सकते हैं।
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) |