# Procedure for Recursive Calculation of Factorial Calculation in SQL Server Hello everyone,

In this section, I will make an example of a procedure that recursively calculates factorial in SQL Server.

First, let’s talk about what factorial is.

The product of numbers starting from 1 up to a certain counting number is called the factorial of that number.

For example, the factorial of 5 (denoted by 5!): 120 = 5 * 4 * 3 * 2 * 1.

What is recursive?

If a structure has the ability to refer to itself, such structures are called recursive structures.

Now let’s move on to the code example.

``````CREATE PROCEDURE CalculateFactorial
(
@Number INTEGER,
@Result INTEGER OUTPUT
)
AS
DECLARE @Input INTEGER;
DECLARE @Output INTEGER;
IF @Number != 1
BEGIN
SELECT @Input = @Number - 1;
EXEC FaktoriyelHesapla @Input, @Output OUTPUT;
SELECT @Result = @Number * @Output;
END;
ELSE
BEGIN
SELECT @Result = 1;
END;
RETURN;

--Çalıştırılması

DECLARE @Result INTEGER;
EXEC CalculateFactorial @Number = 5,              -- integer
@Result = @Result OUTPUT; -- integer
PRINT @Result;``````

When you create and run the above procedure, you will see a result similar to the one below. As can be seen, we have calculated the factorial recursively.

Good luck to everyone in business and life.

68 Views Yavuz Selim Kart

I try to explain what I know in software and database. I am still improving myself by doing research on many programming languages. Apart from these, I am also interested in Graphic Design and Wordpress. I also have knowledge about SEO and Social media management. In short, I am a determined person who likes to work hard.

Don`t copy text!