Monday, March 26, 2012

ms sql server accessing oracle loses precision

We have a view in a 9205 oracle database. We can query fine
and the decimal precision is there.
When we query this same view from ms sql server we lose the precision
so 115.25 becomes 115.
does anyone know a workaround for this?Post your query.|||Check you Locale settings in Control Panel.sql

No comments:

Post a Comment