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.
The following table outlines the restrictions that are applied, based on all recognized XSD simple type enumerations.
Also, SQL Server does not support the NaN value in <xsd:simpleType> declarations. Schemas that include NaN values are rejected by the server.
Simple type |
Limitation |
|---|---|
duration |
The year part has to be within the range of -2^31 to 2^31-1. The month, day, hour, minute, and second must all be within the range of 0 to 9999. The seconds part has an additional three digits of precision to the right of the decimal point. |
dateTime |
The hour part in the time zone subfield must be within the accepted range of -14 to +14. The year part must be within the range of 1 to 9999. The month part must be within the range of 1 to 12. The day part must be within the range of 1 to 31 and must be a valid calendar date. For example, SQL Server detects and returns an error for an invalid date, such as 1974-02-31, because the month of February does not have 31 days. The second component supports 100-nanosecond precision. The timezone indication is optional. SQL Server 2005 supported years in the range -9999 to 9999. SQL Server now supports a more restricted range of years. For more information, see Compare Typed XML to Untyped XML. |
date |
The year part must be within the range of 1 to 9999. The month part must be within the range of 1 to 12. The day part must be within the range of 1 to 31 and must be a valid calendar date. For example, SQL Server detects and returns an error for an invalid date, such as 1974-02-31, because the month of February does not have 31 days. SQL Server 2005 supported years in the range -9999 to 9999. SQL Server now supports a more restricted range of years. For more information, see Compare Typed XML to Untyped XML. |
gYearMonth |
The year part must be within the range of -9999 to 9999. |
gYear |
The year part must be within the range of -9999 to 9999. |
gMonthDay |
The month part must be within the range of 1 to 12. The day part must be within the range of 1 to 31. |
gDay |
The day part must be within the range of 1 to 31 |
gMonth |
The month part must be within the range of 1 to 12. |
decimal |
Values of this type must comply with the format of the SQL numeric type. This type internally represents the support of numbers up to a total of 38 digits, with 10 of those digit positions reserved for fractional precision. |
float |
Values of this type must comply with the format of the SQL real type. |
double |
Values of this type must comply with the format of the SQL float type. |
string |
Values of this type must comply with the format of the SQL nvarchar(max) type. |
anyURI |
Values of this type can be no more than 4000 Unicode characters in length. |
See Also
Reference
Requirements and Limitations for XML Schema Collections on the Server