MS SQL Server Interview Question:

What Happens If NULL Values Are Involved in Bitwise Operations?

Submitted by: Administrator

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

Submitted by: Administrator