MS SQL server create Procedure

CREATE PROCEDURE ProcedureName
    -- Add the parameters for the stored procedure here
    @Param1 int,
    @Param2 int
AS
BEGIN
    SET NOCOUNT ON;

    -- Insert statements for procedure here
    SELECT <@Param1, sysname, @p1>, <@Param2, sysname, @p2>
END

---------------------------------------------------------------
--CALL PROCEDURE
EXEC ProcedureName 

or