By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
create table t (
id int not null primary key identity,
a int,
b int,
c int
);
insert into t(a, b, c) values
( 1, 1, 1),
( 2, null, 2),
(null, 3, 3),
( 4, 4, 4);
4 rows affected
select sum(value)
from t
cross apply (values
(a),
(b),
(c)
) as x(value);
| (No column name) |
|---|
| 25 |
Warning: Null value is eliminated by an aggregate or other SET operation.