password99
Technical User
I need to store values ranging from -999.99 to 999.99
What datatype do you recommend for storing these values?
What datatype do you recommend for storing these values?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Datatype for storing numbers
- Thread starter password99
- Start date
- Status
JohnDTampaBay
Programmer
From BOL:
smallint
Integer data from 2^15 (-32,768) through 2^15 - 1 (32,767).
--Angel![[rainbow]](/data/assets/smilies/rainbow.gif "[rainbow] [rainbow]")
-----------------------------------
Every time I lose my mind, I wonder
if it's really worth finding.
smallint
Integer data from 2^15 (-32,768) through 2^15 - 1 (32,767).
--Angel
-----------------------------------
Every time I lose my mind, I wonder
if it's really worth finding.
JohnDTampaBay
Programmer
Oops! A little too quick.
decimal
Fixed precision and scale numeric data from -10^38 +1 through 10^38 –1.
--Angel
-----------------------------------
Every time I lose my mind, I wonder
if it's really worth finding.
decimal
Fixed precision and scale numeric data from -10^38 +1 through 10^38 –1.
--Angel
-----------------------------------
Every time I lose my mind, I wonder
if it's really worth finding.
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question