create proc sum_avg @chengji varchar(30), @a varchar(20) out, @b varchar(30) out as exec('select '+ @a+'=sum (chengji) from 表chengji group by '+ @chengji) exec('select '+ @b+'=avg (chengji) from 表chengji group by '+ @chengji)---測試 --declare @a varchar(20),@b varchar(30) --sum_avg 'chengji',@a out,@b out ---print @a,@b
@chengji varchar(30),
@a varchar(20) out,
@b varchar(30) out
as
exec('select '+ @a+'=sum (chengji) from 表chengji group by '+ @chengji)
exec('select '+ @b+'=avg (chengji) from 表chengji group by '+ @chengji)---測試
--declare @a varchar(20),@b varchar(30)
--sum_avg 'chengji',@a out,@b out
---print @a,@b
print @b---原來不能這樣寫 print @a,@b