What Happens If NULL Values Are Involved in Arithmetic Operations?

Submitted by: Administrator
If NULL values are involved in arithmetic operations, the result will be numeric NULL values. The following tutorial script shows you some good examples:

SELECT 7+NULL;
GO
-----------
NULL

SELECT 10.02*NULL;
GO
-----------
NULL

SELECT 4.988E+10/NULL;
GO
-----------
NULL

Submitted by: Administrator

Read Online MS SQL Server Job Interview Questions And Answers