sql server中没有@i=@i++这种东西吧?
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
declare @s int
set @s = 99
select (1 + @s) * @s /2
select SUM(number)
from master..spt_values
where type='P' and number between 1 and 99
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楼主结果正解