create proc proc_test
    @month_salary nvarchar(20) --列名
as

declare

@tatal_count int,
@tatal_salary float,
@sql1 nvarchar(500)
begin
set @sql1='select '+ @tatal_count+'=count(*),'+@tatal_salary+'=sum('+@month_salary+') from TbSalary where '+@month_salary+'>0';
exec sp_executesql @sql1, N'@tatal_count int output, @tatal_salary float output', @tatal_count output, @tatal_salary output

print @tatal_count
end

create proc proc_test
    @month_salary nvarchar(20) --列名
as

declare

@tatal_count int,
@tatal_salary float,
@sql1 nvarchar(500)

begin

set @sql1='select @tatal_count=count(*),@tatal_salary=sum('+@month_salary+') from TbSalary where '+@month_salary+'>0';
exec sp_executesql @sql1, N'@tatal_count int output, @tatal_salary float output', @tatal_count output, @tatal_salary output
print @tatal_count

end