You are not logged in. Your edit will be placed in a queue until it is peer reviewed.
We welcome edits that make the post easier to understand and more valuable for readers. Because community members review edits, please try to make the post substantially better than how you found it, for example, by fixing grammar or adding additional resources and hyperlinks.
Required fields*
-
Floats are always exact numbers, and 10.0 will always be 10, never 9.9999999999. You get rounding errors only when trying to represent as a float a number that cannot be exactly representable as a float.Edgar Bonet– Edgar Bonet2017年03月23日 09:52:49 +00:00Commented Mar 23, 2017 at 9:52
-
@EdgarBonet not according technet.microsoft.com/en-us/library/ms187912(v=sql.105).aspx ... I mean a float as type (probably you mean a 'mathematical float' ?Michel Keijzers– Michel Keijzers2017年03月23日 09:58:03 +00:00Commented Mar 23, 2017 at 9:58
-
2Every float represents a number, in the mathematical sense of the word "number", i.e. defined with infinite precision. Most numbers are not representable as floats, and can thus only be approximated by floats. Every single integer in the range ±16777216 (and this include the number 10) is an exact float.Edgar Bonet– Edgar Bonet2017年03月23日 10:05:03 +00:00Commented Mar 23, 2017 at 10:05
-
@EdgarBonet Yes you are completely right about the integers ... I will update the answer. Thanks.Michel Keijzers– Michel Keijzers2017年03月23日 10:34:03 +00:00Commented Mar 23, 2017 at 10:34
default