Suppose your table name is T1,which has two columns Name and Designation.
Procedure Name is InsertIntoT1.
Create proc InsertIntoT1(@Name varchar(50),@Designation varchar(50))
as
begin
insert into T1(Name,Designation)values(@Name,@Designation);
end
/*How to call the stored procedure*/
exec InsertIntoT1 'Sajid Ahmed Shahsroha','Team Lead/Sr.Software Engineer'