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

SQL

SQL Query to Add Two Numbers With Stored Procedure

5 years ago

Add Comment

by admin

[jp_post_view]

In this example,we’ll learn How to Finding The Sum Of The Two Numbers With Stored Procedure.

SQL Query:


Create Procedure sumThree
@n1 int,
@n2 int,
@result int output as
Begin
    Set @result = @n1+@n2
End
--To Execute The Procedure
Declare @result int 
Execute sumThree 5,30,@result output
Select @result

Create Procedure sumThree

@n1 int,

@n2 int,

@result int output as

Begin

Set @result = @n1+@n2

End

--To Execute The Procedure

Declare @result int

Execute sumThree 5,30,@result output

Select @result

SQL Query to Add Two Numbers With Stored Procedure

Like this:

Leave a Comment X

Like this:

You may also like

Leave a Comment X