Collections:
Performing Comparison on Floating Point Numbers in SQL Server
How To Perform Comparison on Floating Point Numbers in SQL Server Transact-SQL?
✍: FYIcenter.com
Comparison operations on approximate (floating point) numbers are also easy to understand. Just watch out rounding operations performed during conversions. Here are two examples of floating point number comparisons:
-- Rounding during implicit conversion makes them equal DECLARE @x FLOAT(24), @y FLOAT(24); SET @x = 0.999999999E+00; SET @y = 0.99999999E+00; SELECT CASE WHEN @x <> @y THEN 'True' ELSE 'False' END; GO False -- Floating point number literals have double precision -- So no rounding SELECT CASE WHEN 0.999999999E+00 <> 0.99999999E+00 THEN 'True' ELSE 'False' END; GO True
⇒ Performing Comparison on Date and Time Values in SQL Server
⇐ Performing Comparison on Exact Numbers in SQL Server
⇑ Boolean Values and Logical Operations in SQL Server Transact-SQL
2017-01-21, 1525🔥, 0💬
Popular Posts:
Why I Can Not Enter 0.001 Second in DATETIME values in SQL Server Transact-SQL? If you enter millise...
What To Do If the StartDB.bat Failed to Start the XE Instance in Oracle? If StartDB.bat failed to st...
What is sqlservr.exe - Process - SQL Server (SQLEX?PRESS) in SQL Server? Process sqlservr.exe is the...
Where to find tutorials to answer some frequently asked questions on Microsoft SQL Server Transact-S...
What Happens If the UPDATE Subquery Returns Multiple Rows in SQL Server? If a subquery is used in a ...