1. Home
  2. Computing & Technology
  3. Databases

Approximate Numeric Data Types in SQL Server

By Mike Chapple, About.com

The approximate numeric data types are not as commonly used as other SQL Server data types used to store numeric information. The exact numeric data types provide more precision and are more commonly used.

Data types in the approximate numeric category include:
  • float variables store 4-byte or 8-byte floating point numbers. They are specified as float(p), where p is 24 for a 4-byte number and 53 for an 8-byte number.
  • real variables store 4-byte floating point numbers and are functionally equivalent to float(24) variables.
If the approximate numeric data types don’t suit your needs, read more about other SQL Server data types.
Explore Databases
About.com Special Features

Stay connected and entertained with reviews on tips on the latest HDTVs, cellphones and more. More >

Easy ways to connect two computers for networking purposes. More >

  1. Home
  2. Computing & Technology
  3. Databases
  4. SQL Server
  5. Approximate Numeric Data Types in SQL Server>

©2009 About.com, a part of The New York Times Company.

All rights reserved.