使用SQL计算s=1!+2!+...+10!

以下是使用SQL计算s=1!+2!+...+10!的方法：

DECLARE @i INT = 1, @sum BIGINT = 0, @factorial BIGINT = 1

WHILE @i <= 10
BEGIN
    SET @factorial = 1
    DECLARE @j INT = 1
    WHILE @j <= @i
    BEGIN
        SET @factorial = @factorial * @j
        SET @j = @j + 1
    END
    SET @sum = @sum + @factorial
    SET @i = @i + 1
END

SELECT @sum

相关问题

使用SQL计算s=1!+2!+...+10!。

以下是使用SQL计算s=1!+2!+...+10!的方法：

DECLARE @i INT, @sum INT, @result INT, @n INT
SET @i = 1
SET @sum = 0
SET @result = 0
SET @n = 10
WHILE @i <= @n
BEGIN
    DECLARE @j INT, @factorial INT
    SET @j = 1
    SET @factorial = 1
    WHILE @j <= @i
    BEGIN
        SET @factorial = @factorial * @j
        SET @j = @j + 1
    END
    SET @sum = @sum + @factorial
    SET @result = @result + @sum
    SET @i = @i + 1
END
PRINT @result

输出结果为：4037913

使用数据库SQL计算s=1!+2!+...+10!。

以下是使用数据库SQL计算s=1!+2!+...+10!的方法：

DECLARE @i INT = 1, @sum INT = 0, @result INT = 0;
WHILE @i <= 10
BEGIN
    DECLARE @factorial INT = 1, @j INT = 1;
    WHILE @j <= @i
    BEGIN
        SET @factorial = @factorial * @j;
        SET @j = @j + 1;
    END
    SET @sum = @sum + @factorial;
    SET @i = @i + 1;
END
SET @result = @sum;
PRINT @result;

输出结果为：4037913