Данная процедура сама разберется, какие из полей числовые.

create table abc
(
pk int identity(1,1) not null,
a int not null,
b int not null,
c float not null,
d varchar(10) not null
)
go

insert into abc (a,b,c,d) values (1,2,3.5,'asdf')
insert into abc (a,b,c,d) values (3,7,4.526,'qwer')
insert into abc (a,b,c,d) values (8,23,8.7564,'rtyu')
go

create procedure SumNums
@tablename sysname
as

DECLARE @SQL nvarchar(4000)
Set @SQL='Select '''+@tablename+''' As TABLENAME'

DECLARE @S nvarchar(12

DECLARE a CURSOR LOCAL FORWARD_ONLY FOR
Select
COLUMN_NAME
From
INFORMATION_SCHEMA.COLUMNS
WHERE
TABLE_NAME=@tablename AND
DATA_TYPE in
(
'bigint',
'decimal',
'float',
'int',
'money',
'numeric',
'real',
'tinyint'
)
ORDER BY
ORDINAL_POSITION

open a

fetch next from a into @s

while @@fetch_Status=0
BEGIN
Set @SQL=@SQL+', SUM('+@s+') As '+@s
fetch next from a into @s
END

Set @SQL=@SQL+' from '+@tablename

exec(@SQL)

close a

deallocate a
go

exec SumNums @tablename='abc'
go

drop procedure SumNums
go

drop table abc
go