Forum Discussion

DM_1007's avatar
DM_1007
Copper Contributor
Oct 30, 2023

SQL server 2019 Inconsistent behavior of real datatype value at 5th precision.

We came across a scenario where the real data type values are not showing consistent results and hoping the Microsoft team has answer and workaround for this situation.   Scenarios: In our current ...
olafhelper's avatar
olafhelper
Bronze Contributor
Nov 01, 2023

DM_1007 

DM_1007 wrote:

We came across a scenario where the real data type values are not showing consistent results and hoping the Microsoft team has answer and workaround for this situation.

And that's the normal behaviour and the reason why the "real" data type is called "Approximate-number data type"; it's by design.

See float and real (Transact-SQL) - SQL Server | Microsoft Learn

Resources