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, 3362🔥, 0💬
Popular Posts:
What Happens to Your Transactions When ERROR 1205 Occurred in MySQL? If your transaction receives th...
What Are the Differences between DATE and TIMESTAMP in Oracle? The main differences between DATE and...
How To Break Query Output into Pages in MySQL? If you have a query that returns hundreds of rows, an...
What Happens to the Current Transaction If a DDL Statement Is Executed in Oracle? If a DDL statement...
Where to find SQL Server database server tutorials? Here is a collection of tutorials, tips and FAQs...