sample81.sql

来自「100多个SQL小程序,包含游标,基本增删改查,希望多你有用」· SQL 代码 · 共 15 行

/* 文件名称: 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))