MS SQL Server Concepts and Programming Question:
What Happens If NULL Values Are Involved in Bitwise Operations?
Answer:
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
SELECT 1 | NULL;
GO
-----------
NULL
SELECT 707 & NULL;
GO
-----------
NULL
SELECT ~NULL;
GO
-----------
NULL
| Previous Question | Next Question |
| What Happens If NULL Values Are Involved in Datetime Operations? | What Happens If NULL Values Are Involved in Comparison Operations? |