In this example,we’ll learn How to Finding The Sum Of The Three Numbers With Stored Procedure.
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 |
Create Procedure sumThree @n1 int, @n2 int, @n3 int, @result int output as Begin Set @result = @n1+@n2+@n3 End --To Execute The Procedure Declare @result int Execute sumThree 5,30,12,@result output Select @result |
