一个递归存储过程的例子

代码：

ALTER PROCEDURE [dbo].[Factorial_ap]
(
    @Number Integer,
    @RetVal Integer OUTPUT
)
AS
    DECLARE @In Integer
    DECLARE @Out Integer
    IF @Number != 1
        BEGIN
   SET @In = @Number -1
   EXEC Factorial_ap @In, @Out OUTPUT
   SET @RetVal = @Number * @Out
        END
    ELSE
        BEGIN
            SET @RetVal = 1
        END
RETURN

调用：

BEGIN
 DECLARE @result INT
 EXEC Factorial_ap 12, @result output
 PRINT @result
END