7-34.sql

来自「SQL2000跟课件学习的源代码 分享共同学习」· SQL 代码 · 共 13 行

DECLARE @i INT, @sum INT
SET @i = 1
SET @sum = 0

WHILE ( @i <= 100 )
BEGIN
  SET @sum = @sum + @i
  SET @i = @i +1
  IF (@sum > 1000)
     BREAK
END
PRINT 'n='+ CAST(@i AS VARCHAR(5))+',Sum='+ CAST(@sum AS VARCHAR(10))