Click here to Skip to main content
11,930,449 members (61,399 online)
Click here to Skip to main content
Articles » Database » Database » General » Revisions

Tagged as


3 bookmarked

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...



Compare Revision Minor Date Status Editor
2 - publicly available No 4-Jan-10 13:46 Available DavidSchmitt
1 No 4-Jan-10 13:46 Composing DavidSchmitt


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


About the Author

Founder -- Software for Humans
Austria Austria
No Biography provided

You may also be interested in...

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