Post

Procedure for Update the Data in Table

658
0
1

Create procedure for

Create procedure prcupdate
@p1 int in ,
@p2 varchar(20) out,
@p3 varchar(20) out,
@p4 salary small money out
As
Select ename = @p2, designation = @p3, salary = @p4
From employee where eid = @p1
Go