Question

请教SQL高手帮忙,SQL Server输出1+2+3...+99+100的结果

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

Answer 1

这样就行了：

declare @i int = 0, @s int = 0
while @i <= 100
begin
set @s=@s+@i --执行相加
set @i=@i+1 --为下个循环作准备
end
select @s --打印结果

Answer 2

1+2+3...+99+100是有算法的，公式是(100+1) * 100 / 2
declare
@i int
set @i = (100 + 1) * 50;
print @i

Answer 3

DECLARE @i INT,@sum INT
SET @i=1
SET @sum=0
WHILE @i<=100
BEGIN
SET @sum=@sum+@i
SET @i=@i+1
END
PRINT @sum

Answer 4

----方法一：
declare @i int
set @i=(1+100)*50
select @i

----方法二：

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