阶乘求法

drop proc prcalcFactorial

create proc prcalcFactorial
 @inyN tinyint,
 @intFactorial int OUTPUT
As

Set @intFactorial = 1
while @inyN > 1
begin
 set @intFactorial=@intFactorial*@inyN
 set @inyN=@inyN-1
end
-------执行部分
declare @intFactorial int
exec prcalcFactorial 5,@intFactorial OUTPUT
select @intFactorial