Click here to Skip to main content
12,349,884 members (21,412 online)
Click here to Skip to main content
Articles » Database » Database » General » Statistics

Tagged as

Stats

11.7K views
3 bookmarked
Posted

MSSQL doesn’t (completely) support IEEE754 floating points (NaNs and infinity)

, 4 Jan 2010 CPOL
After looking for quite a while (it is unbelievable, no?) I have to accept that Microsoft’s SQL Server 2000, 2005 and 2008 do not fully support IEEE-754 floating point numbers. Specifically NaN (Not-a-Number) and +/- Infinity are not allowed. While the 2000 Server seemingly allows such values to...

Views

Downloads

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Share

About the Author

DavidSchmitt
Founder http://dasz.at/ -- Software for Humans
Austria Austria
No Biography provided

You may also be interested in...

| Advertise | Privacy | Terms of Use | Mobile
Web02 | 2.8.160621.1 | Last Updated 4 Jan 2010
Article Copyright 2010 by DavidSchmitt
Everything else Copyright © CodeProject, 1999-2016
Layout: fixed | fluid