Collections:
"IS NULL" - Testing NULL Values in SQL Server
How To Test NULL Values Properly in SQL Server Transact-SQL?
✍: FYIcenter.com
From previous tutorials, you learned that comparing expressions with NULL will always result NULL. So you can not use comparison operators to test if an expression represents a NULL value or not.
To test expressions for NULL values, you should use one of the following special operators:
expression IS NULL -- Returns TRUE if the expression is a NULL value expression IS NOT NULL -- Returns TRUE if the expression is not a NULL value
The tutorial script below shows you how to use IS NULL and IS NOT NULL:
IF 0 IS NULL PRINT 'TRUE' ELSE PRINT 'FALSE'; GO FALSE IF NULL IS NULL PRINT 'TRUE' ELSE PRINT 'FALSE'; GO TRUE IF 1+NULL IS NULL PRINT 'TRUE' ELSE PRINT 'FALSE'; GO TRUE IF 'NULL' IS NOT NULL PRINT 'TRUE' ELSE PRINT 'FALSE'; GO TRUE
⇒ ISNULL() - Replacing NULL Values in Expressions in SQL Server
⇐ NULL Values Involved in Boolean Operations in SQL Server
2017-02-03, 1515🔥, 0💬
Popular Posts:
How To List All Stored Procedures in the Current Database in SQL Server Transact-SQL? If you want to...
Where to find answers to frequently asked questions on INSERT, UPDATE and DELETE Statements in MySQL...
How To Convert Numeric Values to Character Strings in MySQL? You can convert numeric values to chara...
How To Format DATETIME Values to Strings with the CONVERT() Function in SQL Server Transact-SQL? SQL...
How to run Queries with SQL Server Management Studio Express in SQL Server? 1. Launch and connect SQ...