Collections:
NULL Values Involved in Comparison Operations in SQL Server
What Happens If NULL Values Are Involved in Comparison Operations in SQL Server Transact-SQL?
✍: FYIcenter.com
If NULL values are involved in comparison operations, the result will be Boolean NULL values. This behavior is very interesting because you would expect a comparison operation returns only one of the two values: TRUE and FALSE. But SQL Server may return you a third value: NULL.
The tutorial script below proves that "1>NULL" is not returning TRUE or FALSE. It is returning a third value, NULL:
IF 1>NULL PRINT '1>NULL is returning TRUE' ELSE PRINT '1>NULL is not returning TRUE' GO 1>NULL is not returning TRUE IF NOT 1>NULL PRINT '1>NULL is returning FALSE' ELSE PRINT '1>NULL is not returning FALSE' GO 1>NULL is not returning FALSE
Another test proves that "'FYI'=NULL" is not returning TRUE or FALSE. It is returning a third value, NULL:
IF 'FYI'=NULL PRINT '''FYI''=NULL returns TRUE' ELSE PRINT '''FYI''=NULL does not return TRUE' GO 'FYI'=NULL does not return TRUE IF NOT 'FYI'=NULL PRINT '''FYI''=NULL returns FALSE' ELSE PRINT '''FYI''=NULL does not return FALSE' GO 'FYI'=NULL does not return FALSE
⇒ NULL Values Involved in Boolean Operations in SQL Server
⇐ NULL Values Involved in Bitwise Operations in SQL Server
2017-02-03, 1440🔥, 0💬
Popular Posts:
How To List All User Names in a Database in SQL Server? If you want to see a list of all user names ...
What To Do If the StartDB.bat Failed to Start the XE Instance in Oracle? If StartDB.bat failed to st...
How To Convert Numeric Values to Character Strings in MySQL? You can convert numeric values to chara...
How To Recover a Dropped Index in Oracle? If you have the recycle bin feature turned on, dropped ind...
How To Look at the Current SQL*Plus System Settings in Oracle? If you want to see the current values...