用SQL语句编写计算1!+2!+…….n!(n=10)的SQL 语句,并显示计算结果

declare @n int--------------------n=10
declare @i int
declare @j int
declare @rlt int----------------------结果
declare @tmp int
set @n=10;
set @i=1;
set @rlt=0;
while @i<=@n
begin
set @j=1;
set @tmp=1;
while @j<=@i
begin
set @tmp=@j*@tmp
set @j=@j+1
end;
set @rlt=@rlt+@tmp
set @i=@i+1
end
select @rlt本回答被网友采纳