sample66.sql

T-SQL示例大全

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