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, 1553🔥, 0💬
Popular Posts:
How To Assign Debug Privileges to a User in Oracle? In order to run SQL Developer in debug mode, the...
How Fixed Length Strings Are Truncated and Padded in SQL Server Transact-SQL? When the length of the...
How To End a Stored Procedure Properly in SQL Server Transact-SQL? Where the end of the "CREATE PROC...
How to change the data type of an existing column with "ALTER TABLE" statements in SQL Server? Somet...
How to run Queries with SQL Server Management Studio Express in SQL Server? 1. Launch and connect SQ...