Question

‘’SQL使用while 语句求1到100之间的累加和并输出 ‘’

Answer 1

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

Answer 2

declare
iA number(5);
i number(3);
begin
iA:=0;
i:=1 ;
loop
exit when i >100;
iA:= iA+i;
i:=i+1;
end loop;
dbms_output.put_line(iA);
end ;

Answer 3

DECLARE @sum int ,@i int
SET @sum = 1
SET @i = 1
WHILE @i