TSQL编写存储过程计算1!+2!+3!+…+N!

r囧r小猫 2023-01-21 14:23 166阅读 0赞

编写存储过程如下；两层循环；内层计算阶乘，外层相加；

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2JjYm9ibzIxY24_size_16_color_FFFFFF_t_70][]

create procedure sp_getfact @n int
    as
    declare @i int,@j int,@val int,@sval int
    set @i=1
    set @val=0
    while @i<=@n
        begin
            set @j=@i
            set @sval=1
            while @j>1
            begin
                set @sval=@sval*@j
                set @j=@j-1
            end
            set @val=@val+@sval
            set @i=@i+1
        end
    return @val
    go

@n为输入参数；

存储过程创建成功以后；执行一下；先输入一个参数3；

![20210516214555757.PNG][]

看一下结果，9； 1 + 2 + 3\*2\*1 = 9；

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2JjYm9ibzIxY24_size_16_color_FFFFFF_t_70 1][]

然后用语句来执行；结果33；

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2JjYm9ibzIxY24_size_16_color_FFFFFF_t_70 2][]

declare @myfact int
    exec @myfact = sp_getfact @n=4
    SELECT	'结果：' = @myfact

1+2+6+4\*3\*2\*1 = 9 + 24 = 33;    没错；

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2JjYm9ibzIxY24_size_16_color_FFFFFF_t_70]: /images/20221020/7332e115acef4dd0b60aa722a15a2f88.png
[20210516214555757.PNG]: /images/20221020/93574eb189f8412b8704668449390679.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2JjYm9ibzIxY24_size_16_color_FFFFFF_t_70 1]: /images/20221020/6a53463e597a4627ad1ce197e5bb9de5.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2JjYm9ibzIxY24_size_16_color_FFFFFF_t_70 2]: /images/20221020/1b3f6b5276cb42bd8848a54d8c83f185.png