Collections:
NULL Values Involved in Boolean Operations in SQL Server
What Happens If NULL Values Are Involved in Boolean Operations in SQL Server Transact-SQL?
✍: FYIcenter.com
If NULL values are involved in Boolean operations, the result will vary depending on the operator type. For AND operator, FALSE takes precedence over NULL. The result can be summarized in a table below:
AND TRUE FALSE NULL TRUE true false null FALSE false false false NULL null false null
For OR operator, TRUE takes precedence over NULL. The result can be summarized in a table below:
OR TRUE FALSE NULL TRUE true true true FALSE true false null NULL true null null
The tutorial script below shows you that NULL AND FALSE returns FALSE:
IF 0=NULL AND 0=1 PRINT 'NULL AND FALSE returns TRUE' ELSE PRINT 'NULL AND FALSE does not returns TRUE' GO NULL AND FALSE does not returns TRUE IF NOT (0=NULL AND 0=1) PRINT 'NULL AND FALSE returns FALSE' ELSE PRINT 'NULL AND FALSE does not returns FALSE' GO NULL AND FALSE returns FALSE
⇒ "IS NULL" - Testing NULL Values in SQL Server
⇐ NULL Values Involved in Comparison Operations in SQL Server
2017-02-03, 1673🔥, 0💬
Popular Posts:
What are DDL (Data Definition Language) statements for tables in SQL Server? DDL (Data Definition La...
What Is "mysqld" in MySQL? "mysqld" is MySQL server daemon program which runs quietly in background ...
How To Connect ASP Pages to Oracle Servers in Oracle? If you are running Windows IIS Web server and ...
What Are the Differences between DATE and TIMESTAMP in Oracle? The main differences between DATE and...
Why I Can Not Enter 0.001 Second in DATETIME values in SQL Server Transact-SQL? If you enter millise...