--计算1-100的和
declare @int int=1;
declare @total int=0;
while(@int<=100)
begin
set @total=@total+@int;
set @int=@int +1;
end
select @total
--计算1-100偶数的和
declare @index int;
declare @sum int;
set @index=1;
set @sum=0;
while(@index<=100)
begin
if(@index%2=0)
begin
set @sum=@sum+@index
end
set @index=@index+1;
end
select @sum;