Store Procedure with single parameter

 Create procedure SpGetEmployeeById
@Id int  // 👈 variable name
as
begin
Select * from Test_EmployeeTbl where Id =@Id
end

Note:👇

-> @:- Parameter of Store procedure.
-> @id:- Variable name

How to show the data using id👇

       SpGetEmployeeById  3     // Here 3 is id

Output 

Store procedure with multiple parameter,changing the parameter order. Next page 👉 Click Here