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 |
|
giszzmo
Starting Member
29 Posts |
 Posted - 2015-04-07 : 22:57:22
|
| Hi, We are in the process of bringing our data over from Oracle to SQL so now some of the conversions are coming out differently. I need to make them the same in SQL as they were intended in Oracle. One such conversion I have isOracleDatatype Length Precision Scalenumber 22SQLDatatype Length Precision Scalenumeric 17 38 0I understand how it got 38 and 0 but I don't understand how it got the length of 17. Also, how would I change it (on the SQL side) to match that of Oracle? If anyone could point me in the right direction. Thanks! |
|
|
Kristen
Test
22859 Posts |
Posted - 2015-04-08 : 04:02:01
|
I'm guessing that your column datatype, in MS SQL, is FLOAT and perhaps you need to use DECIMAL instead? (or NUMERIC which is a synonym for DECIMAL - not sure which flavour Oracle uses  ) |
 |
|
|
|
|
|
Oracle Number length to SQL Numeric length