Hi,
I am updating the solution 1.
Select Name, ColumnA, ColumnB, Test, TestAA, (ISNULL(ColumnA, 0) + ISNULL(ColumnB, 0) + ISNULL(Test, 0) + ISNULL(TestAA, 0)) AS 'SUM' from yourtableName
if you do not use
ISNULL
function then, if anyone value goes
NULL
then whole sum will go null. so, using isnull function we will replace null value with 0.
hope it helps.