Performing Comparison on Exact Numbers in SQL Server

Q

How To Perform Comparison on Exact Numbers in SQL Server Transact-SQL?

✍: FYIcenter.com

A

Comparison operations on exact numbers of data types: BIT, INT, NUMERIC, etc., are very easy to understand. Here are some simple examples: 

-- BIT value comparison
DECLARE @x BIT, @y BIT;
SET @x = 0; 
SET @y = 1; 
SELECT CASE WHEN @x > @y THEN 'True' ELSE 'False' END;
GO
False

DECLARE @x INT, @y INT;
SET @x = -5; 
SET @y = 9; 
SELECT CASE WHEN @x > @y THEN 'True' ELSE 'False' END;
GO
False

DECLARE @x NUMERIC(9,2), @y NUMERIC(9,2);
SET @x = -5.25; 
SET @y = -5.15; 
SELECT CASE WHEN @x > @y THEN 'True' ELSE 'False' END;
GO
False

 

⇒Boolean Values and Logical Operations in SQL Server Transact-SQL

⇒⇒SQL Server Transact-SQL Tutorials

2017-01-21, 281👍, 0💬

General MySQL Oracle SQL Server