[Limitation] SQL Server only supports millisecond precision for simple types that have second components other than xs:time and xs:dateTime, and 100-nanosecond precision for xs:time and xs:dateTime. SQL Server puts limitations on all recognized XSD simple type enumerations. SQL Server does not support using the "NaN" value in declarations. For more information, seeValues for Declarations. [Item] 
values