Home >> FAQs/Tutorials >> SQL Server FAQ

SQL Server FAQ - FLOAT and REAL - Approximate Numeric Data Types

By: FYIcenter.com

(Continued from previous topic...)

What Are Approximate Numeric Data Types?

Approximate numeric data types are used to store numeric values with floating decimal points. SQL Server 2005 supports the following approximate numeric data types:

  • FLOAT - Floating point values with a fixed number of bits n for the mantissa part defined as FLOAT(n). FLOAT values are in the range of -1.79E+308 to -2.23E-308, 0 and 2.23E-308 to 1.79E+308.
  • REAL - Same as FLOAT(24), also called single precision floating point numbers.

The DOUBLE PRECISION data type is supported as a synonym of FLOAT(53).

Here are some good examples of approximate numeric values:

PRINT 9.22337203685e+010; -- FLOAT(53)
PRINT 9.22337e+010; -- FLOAT(24)

(Continued on next topic...)

  1. What Is SQL Language?
  2. What Is Transact-SQL Language?
  3. What Is a Transact-SQL Statement?
  4. How To Start and End Transact-SQL Statements?
  5. How To Enter Comments in Transact-SQL Statements?
  6. What Is a Transact-SQL Statement Batch?
  7. What Happens to a Statement Batch If There Is a Compilation Error?
  8. How To Use GO Command in "sqlcmd"?
  9. How To Create User Messages with PRINT Statements?
  10. How Many Categories of Data Types Used by SQL Server?
  11. What Are Exact Numeric Data Types?
  12. What Are Approximate Numeric Data Types?
  13. What Are Date and Time Data Types?
  14. What Are Character String Data Types?
  15. What Are Unicode Character String Data Types?
  16. What Are Binary String Data Types?
  17. What Are the Differences between CHAR and NCHAR?
  18. What Are the Differences between CHAR and VARCHAR?
  19. What Are the Differences between DECIMAL and FLOAT?

Related Articles:


Other Tutorials/FAQs:


Related Resources:


Selected Jobs: