?
Solved

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

Posted on 2008-06-18
3
Medium Priority
?
1,409 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

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

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

There are some very powerful Dynamic Management Views (DMV's) introduced with SQL 2005. The two in particular that we are going to discuss are sys.dm_db_index_usage_stats and sys.dm_db_index_operational_stats.   Recently, I was involved in a di…
In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
SQL Database Recovery Software repairs the MDF & NDF Files, corrupted due to hardware related issues or software related errors. Provides preview of recovered database objects and allows saving in either MSSQL, CSV, HTML or XLS format. Ensures recov…
Stellar Phoenix SQL Database Repair software easily fixes the suspect mode issue of SQL Server database. It is a simple process to bring the database from suspect mode to normal mode. Check out the video and fix the SQL database suspect mode problem.

609 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