Question

怎么用SQL SERVER 2000语言完成“计算1+2+3+····+100的和并输出”

Answer 1

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