declare @times int, @sum int select @times=1, @sum=0 while @times < 1000 begin if (@times/11=1.0*@times/11 or @times/7=1.0*@times/7) and not(@times/11=1.0*@times/11 and @times/7=1.0*@times/7) begin print @times --调试,打印出哪些是符合条件的数值 select @sum=@sum+@times end
select @times = @times + 1 end
print @sum -- 直接打印结果集 select @sum as SumExp -- 以表返回结果集