34,593
社区成员
发帖
与我相关
我的任务
分享
CREATE TABLE #tb(i int);
DECLARE @i INT
SET @i=1
WHILE @i<100
BEGIN
INSERT INTO #tb(i) VALUES(@i)
SET @i=@i+1
END
SELECT SUM(i) FROM #tb
CREATE TABLE #tb(i int);
DECLARE @i INT
SET @i=1
WHILE @i<100
BEGIN
INSERT INTO #tb(i) VALUES(@i)
SET @i=@i+1
END
SELECT SUM(i) FROM #tb
楼主结果正解
select SUM(number)
from master..spt_values
where type='P' and number between 1 and 99
declare @s int
set @s = 99
select (1 + @s) * @s /2