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.

 All Forums
 SQL Server 2008 Forums
 Transact-SQL (2008)
 truncation data

Author  Topic 

wided
Posting Yak Master

218 Posts

Posted - 2011-07-08 : 05:44:36

I need to import data from an Oracle database on a database SQL SERVER 2008
I have a field in ORACLE numeric type that contains the value (0.106849315068493)
I have not found the correcpondance type (float, moent, decimal (10,10) ...
I tried everything, I still have a problem with truncation

thanks

webfred
Master Smack Fu Yak Hacker

8781 Posts

Posted - 2011-07-08 : 05:47:16
decimal(16,15) ?


No, you're never too old to Yak'n'Roll if you're too young to die.
Go to Top of Page

wided
Posting Yak Master

218 Posts

Posted - 2011-07-08 : 06:51:28
THANKS webfred

it does not work
i have a field contains (0.106849315068493E-5)
no correspondance

even varchar(100)
Go to Top of Page
   

- Advertisement -