NULL Values Involved in Bitwise Operations in SQL Server

Q

What Happens If NULL Values Are Involved in Bitwise Operations in SQL Server Transact-SQL?

✍: FYIcenter.com

A

If NULL values are involved in bitwise operations, the result will be binary NULL values. The following tutorial script shows you some good examples: 

SELECT 1 | NULL;
GO
-----------
NULL

SELECT 707 & NULL;
GO
-----------
NULL

SELECT ~NULL;
GO
-----------
NULL

 

⇒Working with NULL Values in SQL Server Transact-SQL

⇒⇒SQL Server Transact-SQL Tutorials

2017-02-03, 408👍, 0💬

General MySQL Oracle SQL Server