create proc sumvalues @s int=10, @e int=20as declare @sum int=0while(@s<@e)begin if(@s%2=0) begin set @sum=@sum+@s end set @s=@s+1endselect @sum---下面为取值调用exec sumvalues 10,20