I don't understand the meaning of maximum precision values,
I get the following text from the MSSQL help file!!
The precision of the float datatype uses less storage space for
different ranges of precision. For example, consider the following
declaration of float (n):
Declare @mf float(n)
These are the ranges of precision values permitted.
Where n = Version 6.0 and earlier Version 6.5
1-7 real, 4 bytes real, 4 bytes
8-15 float, 8 bytes real, 4 bytes
16-23 float, 8 bytes real, 4 bytes
24-53 float, 8 bytes float, 8 bytes
Can anyone tell me that what's the actual range of real dataype and float?
I don't understand why a 4 bytes real datatype can store a value over 32767
???
Thanks alot!!!
SQL Server 7.0 has not changed the definition of the real and float data
types, so the following is from the SQL Server 7.0 Books Online:
float
Floating precision number data from -1.79E + 308 through 1.79E + 308.
real
Floating precision number data from -3.40E + 38 through 3.40E + 38.
3 Head Mumkey <lucky_...@263.com> wrote in message
news:839hr0$ipd$1...@hfc.pacific.net.hk...