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 |