SELECT (NULL + 1+345) [Sum of NULL and value.]
Loading
SELECT (NULL + 1+345) [Sum of NULL and value.]
As per the given scenario, the output should be NULL but in case you want to ignore NULL and retrieve overall SUM of the other values, you can use IsNull() check and replace NULL with the 0 (zero) value.
NULL