ProcedureStore

USE [**DB]

GO

IF EXISTS (SELECT * FROM sys.objects WHERE object_id =OBJECT_ID(N'PROC_NAME') AND TYPE IN (N'P',N'PC'))

DROP PROC PROC_NAME

GO

CREATE PROC PROC_NAME

@**_ID INT=NULL,

@**_NAME NCHAR(100)=NULL

AS

BEGIN

END

GO