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, 1441🔥, 0💬
Popular Posts:
How to set database to be READ_ONLY in SQL Server? Databases in SQL Server have two update options: ...
How AdventureWorksLT tables are related in SQL Server? There are 12 user tables defined in Adventure...
What Are Out-of-Range Errors with DATETIME values in SQL Server Transact-SQL? When you enter DATETIM...
How To List All User Names in a Database in SQL Server? If you want to see a list of all user names ...
How To Calculate Age in Days, Hours and Minutes in SQL Server Transact-SQL? On many Web sites, news ...