Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
dnf999
Constraint Violating Yak Guru
253 Posts |
 Posted - 2011-11-01 : 12:28:59
|
| Hi I'm trying to specify a datatype for data which contains such values as:6.81220000058966However if I specify the datatype as Float it imports as:6.81220006942749I've tried using decimal datatype with various parameters but no luck. Is there any way I can import the data as is?p.s Data to be imported is contained within a .txt file and the number of decimal values can greatly different the fieldPlus I would not like to import as a varchar and then convert.Thanks!! |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-11-01 : 12:36:20
|
| float is an approximate floating data field so if you want to import figures till last decimal precision you need to use Decimal or Numeric. you can determine which is largest precision currently in and use it for scale value------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
|
|
|
Decimal place import error