Creating Stored Procedure in SQL Server

1.  From View Menu Goto Server Explorer.
2. Expand your Database -> Stored Procedures -> Right Click -> Add New Stored Procedure.
3. You will see the stored procedure as below.

CREATE PROCEDURE dbo.StoredProcedure1
/*
(
@parameter1 int = 5,
@parameter2 datatype OUTPUT
)
*/
AS
/* SET NOCOUNT ON */

RETURN