Approximate number data types for use with floating point numeric data. Floating point data is approximate; not all values in the data type range can be precisely represented.
n is | Precision | Storage size |
---|---|---|
1-24 | 7 digits | 4 bytes |
25-53 | 15 digits | 8 bytes |
The Microsoft® SQL Server™ float[(n)] data type conforms to the SQL-92 standard for all values of n from 1 to 53. The synonym for double precision is float(53).
ALTER TABLE | DECLARE @local_variable |
CAST and CONVERT | DELETE |
CREATE TABLE | INSERT |
Data Type Conversion | SET @local_variable |
Data Types | UPDATE |