9db.txt

the original code of the book the principle and practice in sql server 2005

declare @x int,@sum int
select @x=0,@sum=0
while @x<=100
begin
     set @x=@x+1
 
   
   if @x%2=1
   continue
  set @sum=@sum+@x

end

print '从１加到１００所有的偶数之和是：'+cast(@sum as varchar(50))

declare @x int,@sum int
set @x=0
set @sum=0
bz:
  set @x=@x+1
 
 
  set @sum=@sum+@x
 while @x<200 goto bz
print '利用goto语句求1到100之间所有偶数之和：'+cast(@sum as varchar(50))




declare @x int ,@sum int,@xz int
set @x=1
set @sum=1
set @xz=1
while @x<5
begin
   set @x=@x+1
   set @xz=@xz*@x
   set @sum=@sum+@xz
   
end
print '１！+２！+3!+4!+5!='+cast(@sum as varchar(50))



declare @x int,@sum int
select @x=0,@sum=0
while @x<=100
 begin
   if @x%2=0 or @x%3=0
   begin
     set @sum=@sum+@x
   end
   set @x=@x+1
 end
print '１００之内是２的倍数或者３的倍数的数之和是：'+cast(@sum as varchar(50))