删除存储过程

清华大佬耗费三个月吐血整理的几百G的资源,免费分享!....>>>

IF EXISTS (SELECT * FROM sysobjects WHERE TYPE='P' AND name='SP_NAME')
DROP PROCEDURE SP_NAME
GO