Recursive call sample for stored procedures in SQL Server _mssql

Recursion refers to the case where the code fragment calls itself; the danger is that if you call itself once, then how to prevent him from repeatedly calling itself. This means providing a recursive test to ensure that the appropriate time to jump out.

Recursive invocation in the stored procedure, as exemplified by the class.

Recursion

CREATE PROC [dbo]. [Usp_spfactorial]
@InputValue int,
@OuputValue int OUTPUT
as
BEGIN
   DECLARE @InValue  int;
   DECLARE @OutValue  INT;
    IF (@InputValue!=1)
      BEGIN
         SET @InValue = @InputValue-1;
         EXEC spfactorial @InValue, @OutValue OUTPUT;
         SELECT @OuputValue = @InputValue * @OutValue;
      End
    ELSE
      BEGIN
      SET @OuputValue = 1;
      End End

When you create this stored procedure, you will encounter a report message