SQL 编程计算S=1!+2!+3!+4!+5!+6!

1、建立一个函数create function jiechen(@a int)
returns float
as
begin
declare @b float
declare @i int
set @i=1
set @b=1
while @i<=@a
begin
select @b=@b*@i
set @i=@i+1
end
return @b
end2、使用循环declare @a int
declare @b float
set @b=1
set @a=1
while @a<=6
begin
select @b=@b+dbo.jiechen(@a)
set @a=@a+1
end
select @b本回答被网友采纳