i use openquery to save values from sql server to RDB through ORACLE RDB DRIVER ,ODBC
insert into OPENQUERY([RDB_ODBC_ACCOUNTING],
'select * from test')
(f1) values( 0.001)
the value saved in rdb= 100 any suggest?
Asked
Active
Viewed 86 times
0
-
you might have to check the corresponding data type in RDB,that corresponds to float in sqlserver – TheGameiswar Apr 24 '17 at 08:12
-
if i save 1.001 or 0.123 it will save correctly but just if it 0.0xxxx – hussein Apr 24 '17 at 08:19