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

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 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.