7-33.sql

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

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

LabelLoop:		/* 标签 */
  SET @sum = @sum + @i
  SET @i = @i +1
IF (@i <= 100) GOTO LabelLoop	/* 转移到LabelLoop标签 */

PRINT 'Sum='+ CAST(@sum AS VARCHAR(20))