Where n is the number of bits that are used to store the mantissa of the float number in scientific notation and, therefore, dictates the precision and storage size. If n is specified, it must be a value between 1 and 53. The default value of n is 53.

nvalue

Precision

Storage size

1-24

7 digits

4 bytes

25-53

15 digits

8 bytes

Note:

SQL Server 2005 treats n as one of two possible values. If 1<=n<=24, n is treated as 24. If 25<=n<=53, n is treated as 53.

The SQL Server float[(n)] data type complies with the SQL-92 standard for all values of n from 1 through 53. The synonym for double precision is float(53).