7-33.sql

SQL2000跟课件学习的源代码 分享共同学习

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))