Collections:
Performing Comparison on Exact Numbers in SQL Server
How To Perform Comparison on Exact Numbers in SQL Server Transact-SQL?
✍: FYIcenter.com
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
⇒ Performing Comparison on Floating Point Numbers in SQL Server
⇐ What Are Comparison Operations in SQL Server
⇑ Boolean Values and Logical Operations in SQL Server Transact-SQL
2017-01-21, 1550🔥, 0💬
Popular Posts:
How To Calculate DATETIME Value Differences Using the DATEDIFF() Function in SQL Server Transact-SQL...
What are DDL (Data Definition Language) statements for tables in SQL Server? DDL (Data Definition La...
What Are Date and Time Functions in MySQL? MySQL offers a number of functions for date and time valu...
How To Assign Debug Privileges to a User in Oracle? In order to run SQL Developer in debug mode, the...
How To Find Out What Privileges a User Currently Has in Oracle? Privileges granted to users are list...