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, 1433🔥, 0💬
Popular Posts:
Where to find answers to frequently asked questions on Managing Security, Login and User in SQL Serv...
How To Query Tables and Loop through the Returning Rows in MySQL? The best way to query tables and l...
How To Convert Numeric Values to Integers in SQL Server Transact-SQL? Sometimes you need to round a ...
What Is "mysqld" in MySQL? "mysqld" is MySQL server daemon program which runs quietly in background ...
What Happens If the UPDATE Subquery Returns Multiple Rows in MySQL? If a subquery is used in a UPDAT...