sample66.sql

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

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

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

WHILE (@Number < 11)
  BEGIN
    SET @Total = @Total + @Number
    SET @Number = @Number + 1
  END

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