Query Examples For Lessons

Finding The Sum Of The Three Numbers With Stored Procedure

6 years ago

1,460 Views

In this tutorial web William create a Procedure that Sums Three numbers. The numbers will be written by parametter. Lets do it.

Create Procedure sumThree
@n1 int,
@n2 int,
@n3 int,
@result int output as
Begin
    Set @result = @n1+@n2+@n3
End

Create Procedure sumThree

@n1 int,

@n2 int,

@n3 int,

@result int output as

Begin

Set @result = @n1+@n2+@n3

End

After run the code above we will get successful message. Now we sum any three numbers we want running the code below.

Execute sumThree 5,7,12

1	Execute sumThree 5,7,12