Click here to Skip to main content
Click here to Skip to main content
Search within:




Articles » Database » Database » General » Downloads
 
Comments & Discussions

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

By , 4 Jan 2010
 
No downloads associated with this content

By viewing downloads associated with this article you agree to the Terms of use and the article's licence.

If a file you wish to view isn't highlighted, and is a text file (not binary), please let us know and we'll add colourisation support for it.

License

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

About the Author

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

About Article
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...
Type Tip/Trick
Licence CPOL
First Posted 4 Jan 2010
Views 5,269
Bookmarked 3 times
Top News

Skills that self-taught computer programmers lack

Get the Insider News free each morning.
Related Videos
Floating Point in .NET part 1: Concepts and Formats
Division By Zero Doesn't Always Raise An Exception
A Collection of JavaScript Gotchas
Five Tips for Floating Point Programming
Demystify C# floating-point equality and relation operations
A 3D Plotting Library in C#
Persian Gulf in 3D Anaglyph
Optimized Sparse Float Array
A New Perspective on Viewing
Arithmetic Overflow Checking using checked/unchecked
Interpreting Intel 80-bit Long Double Byte Arrays
Fixed Point Class
Text To Image With Rotation For The Web
Duplicate songs detector via audio fingerprinting
Strtod in C# – Part 1: The specification
Floating point utilites
Convert Binary Single Precision Value to Float in JavaScript
3D Pie Chart
Fountain OpenGL Application Walkthrough
Text Documents Clustering using K-Means Algorithm
Permalink | Advertise | Privacy | Mobile
Web01 | 2.6.130619.1 | Last Updated 4 Jan 2010
Article Copyright 2010 by DavidSchmitt
Everything else Copyright © CodeProject, 1999-2013
Terms of Use
Layout: fixed | fluid