sp적용시 기존 sp 삭제하고 생성

IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'dbo.UP_SPNAME) AND type in (N'P', N'PC'))
 DROP PROCEDURE dbo.UP_SPNAME
GO