while-loop.sql

sql server 2000 系统 数 据 库 编 程

declare @sum int
declare @i int
set @sum = 0
set @i = 1
while @i <= 100
begin
set @sum = @sum + @i
set @i = @i + 1
end
print @sum