删除存储过程

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

编程技巧