SQL 使用WHILE语句求1~10之间的累加各，并输出结果，怎么编写，请详细写出来。

Question

如题所述

Answer 1

DECLARE @I INT
,@s int
SET @I = 1
SET @S = 0
WHILE @I <=10
BEGIN
SET @S = @S + @I
PRINT @S --这是累加的和
PRINT @I
SET @I= @I+1
CONTINUE
END本回答被提问者采纳

Answer 2

declare @num int
declare @sum int
set @sum=0
set @num=1
while (@num<=10)
begin
set @sum=@sum+@num
set @num=@num+1
end
print @sum