Hi ,
I noticed a wierd thing with SQL Server ServicePack 1 SQLServer2014SP1-KB3058865-x64-ENU.exe from
https://www.microsoft.com/en-us/download/details.aspx?id=46694
After installation when I executed a SQL query against a Linked Oracle Server I got the decimal values truncated and it only returned the value before the decimal seperator..it was not rounding off either. So a value like -2035.7654 was returned as -2035
After uninstalling the Service Pack1 I re-ran the same SQL Query and it started returning numbers with decimal seperator -2035.7654.
I hope Microsoft fixes it soon.
I noticed a wierd thing with SQL Server ServicePack 1 SQLServer2014SP1-KB3058865-x64-ENU.exe from
https://www.microsoft.com/en-us/download/details.aspx?id=46694
After installation when I executed a SQL query against a Linked Oracle Server I got the decimal values truncated and it only returned the value before the decimal seperator..it was not rounding off either. So a value like -2035.7654 was returned as -2035
After uninstalling the Service Pack1 I re-ran the same SQL Query and it started returning numbers with decimal seperator -2035.7654.
I hope Microsoft fixes it soon.