• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1453
  • Last Modified:

How do I add a double data type column to a table?

I need to store double numbers into a table such as  "3.35E+178" , "5.88E+307", "1.5E-06 "what is the best data type to store them? I was thinking about double I am not sure ho to do it.
0
rbmacct
Asked:
rbmacct
1 Solution
 
YiogiCommented:
sql float. Thats equivalent to double. There is no double in SQL. Real is equivalent to float in C and float is equivalent to double in C
0
 
sbagireddiCommented:
Float or real data type.

Check sql server books online depending on your range.
0
 
rbmacctAuthor Commented:
Thanks.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: SQL Server Core 2016

This course will introduce you to SQL Server Core 2016, as well as teach you about SSMS, data tools, installation, server configuration, using Management Studio, and writing and executing queries.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now