--计算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;