求1+2+3+4+100。请用T-SQL语句完成

使用WHILE循环：

DECLARE @sum INT = 0 DECLARE @i INT = 1

WHILE (@i <= 100) BEGIN SET @sum = @sum + @i SET @i = @i + 1 END

SELECT @sum

使用递归CTE：

WITH nums(n) AS ( SELECT 1 AS n UNION ALL SELECT n + 1 FROM nums WHERE n < 100 ) SELECT SUM(n) AS result FROM nums

使用公式：1+2+3+...+n=n*(n+1)/2

SELECT 100*(100+1)/2 AS result