Thursday, June 11, 2015

Bug: SQL 2014 SP1 truncates decimal values.

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.