Write queries in sp one by one with their respective valid parameter.
I think you should give a try than meke question here. Anyways...
CREATE PROCEDURE XYZ<br />
@Name VARCHAR(50),<br />
@Parameter2 INT,<br />
........<br />
.....<br />
AS<br />
BEGIN<br />
<br />
Insert INTO tbl_ABC(List of columns in which value to be inserted..) VALUES(Parameters..)<br />
<br />
....... Insert query 2 .............<br />
<br />
END