T-SQL 中 while 循环小练习
-- 1. 1-100之间的所有偶数之和
declare @sum int , @num int
set @sum = 0
set @num = 1
while @num<=100
begin
if @num % 2 = 0
begin
set @sum += @num
end
set @num+=1
end
print '1-100之间所有偶数和为:'+str(@sum);
输出结果:
1-100之间所有偶数和为: 2550
-2.计算1-100之间能被9整除的所有数之和
declare @num int , @sum int , @count int
set @num = 1
set @sum = 0
set @count = 0
while @num <= 100
begin
if @num % 9 = 0
begin
set @count += 1
set @sum+= @num
end
set @num += 1
end
print '1-100之间能被9整除的所有数个数为:'+str(@count);
print '1-100之间能被9整除的所有数之和为:'+str(@sum);
输出结果:
1-100之间能被9整除的所有数个数为: 11
1-100之间能被9整除的所有数之和为: 594