--DELETE the existing script.
IF  EXISTS (SELECT 1
            FROM   sys.objects
            WHERE  object_id = OBJECT_ID(N'[dbo].[p_{name}]')
            AND    TYPE IN (N'P', N'PC'))

    DROP PROCEDURE [dbo].[p_{name}]
GO


SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE PROCEDURE [dbo].[p_{name}] 
AS 
BEGIN
    SET NOCOUNT ON;
END
GO

/******************************  TESTING SCRIPT  ******************************
EXEC [p_{name}]
*******************************************************************************/