sample81.sql

T-SQL示例大全

/* 文件名称: Sample81.sql */

DECLARE @Number int, @Total int
SET @Number = 0
SET @Total = 0

CountLoop:
  SET @Total = @Total + @Number
  SET @Number = @Number + 1

IF @Number < 11
   GOTO CountLoop

PRINT '1+2+...+10 = '+CAST(@Total AS char(2))