Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

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

Posted on 2008-06-18
3
Medium Priority
?
1,405 Views
Last Modified: 2010-04-21
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
Comment
Question by:rbmacct
3 Comments
 
LVL 8

Accepted Solution

by:
Yiogi earned 375 total points
ID: 21817229
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
 
LVL 8

Expert Comment

by:sbagireddi
ID: 21817243
Float or real data type.

Check sql server books online depending on your range.
0
 
LVL 1

Author Closing Comment

by:rbmacct
ID: 31468576
Thanks.
0

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

When writing XML code a very difficult part is when we like to remove all the elements or attributes from the XML that have no data. I would like to share a set of recursive MSSQL stored procedures that I have made to remove those elements from …
So every once in a while at work I am asked to export data from one table and insert it into another on a different server.  I hate doing this.  There's so many different tables and data types.  Some column data needs quoted and some doesn't.  What …
This course is ideal for IT System Administrators working with VMware vSphere and its associated products in their company infrastructure. This course teaches you how to install and maintain this virtualization technology to store data, prevent vuln…
Integration Management Part 2

886 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question