float and real (Transact-SQL)
Approximate-number data types for use with floating point numeric data. Floating point data is approximate; therefore, not all values in the data type range can be ... Values of float are truncated when they are converted to any integer type. When you wan...