C#,Windows Form, WPF, LINQ, Entity Framework Examples and Codes

SQL

Calculating Factorial of Given Number in SQL with Stored Procedure

3 years ago

[jp_post_view]

In this tutorial we will write “Stored Procedure” calculates the factorial of a number. That is specified at below.


Create procedure factor(@number int)
as begin
Declare @i int = 1,@result int=1
while (@i<=@number)
Begin
	Set @result = @result * @i
	Set @i += 1
End
Select @result
End

Create procedure factor(@number int)

as begin

Declare @i int = 1,@result int=1

while (@i<=@number)

Begin

Set @result = @result * @i

Set @i += 1

End

Select @result

End

You must execute the code ebove and get succesful message. Then By running the following code, you can calculate the factorial of the number you want.


Execute factor 5

Execute factor 5

Result:120

Calculating Factorial of Given Number in SQL with Stored Procedure

Like this:

Leave a Comment X

Like this:

You may also like

Leave a Comment X