Solved

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

Posted on 2008-06-18
3
1,390 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 125 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

Why You Should Analyze Threat Actor TTPs

After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

Join & Write a Comment

Suggested Solutions

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 article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…
This video gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're looking for how to monitor bandwidth using netflow or packet s…

706 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

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now