MS SQL Server Concepts and Programming Question:

Download Job Interview Questions and Answers PDF

What Happens If NULL Values Are Involved in Bitwise Operations?

MS SQL Server Interview Question
MS SQL Server Interview Question

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


Download MS SQL Server Interview Questions And Answers PDF

Previous QuestionNext Question
What Happens If NULL Values Are Involved in Datetime Operations?What Happens If NULL Values Are Involved in Comparison Operations?