SQL

recursive stored procedure in sql server

CREATE PROCEDURE [dbo].[Factorial_ap]

(
    @Number Integer,
    @RetVal Integer OUTPUT

)

AS
    DECLARE @In Integer
    DECLARE @Out Integer
    IF @Number != 1
        BEGIN
        SELECT @In = @Number – 1
        EXEC Factorial_ap @In, @Out OUTPUT
        SELECT @RetVal = @Number * @Out
    END
        ELSE
            BEGIN
                SELECT @RetVal = 1
            END

RETURN