Store procedure with multiple parameter

 Store procedure with multiple parameter,changing the parameter order.

Create procedure SpGetEmployeeByIdAndName
@Id int,
@name varchar(50)
as
begin
Select * from Test_EmployeeTbl where Id =@Id and Name=@name
end

 Show the data :👇

SpGetEmployeeByIdAndName  4, 'Gulsan'

 

 

 Alter with store procedure Next page 👉 Click here