As a quick and dirty, I would do this:
with counts as (
select * from
(select count (*) as Col1 from sys.columns where (column_id = 1)) x
cross apply
(Select Count (*) as Col2 from sys.columns where (column_id = 2)) y
cross apply
(Select Count (*) as Col3 from sys.columns where (column_id = 3)) z
)
select Col1, Col2, Col3, Col1+Col2+Col3 as SumOfColumns from counts
______________________________________________________________________________
How I want a drink, alcoholic of course, after the heavy lectures involving quantum mechanics.