删除存储过程

SQL Server删除存储过程 无 IF EXISTS (SELECT * FROM sysobjects WHERE TYPE='P' AND name='SP_NAME')DROP PROCEDURE SP_NAMEGO

SQL Server删除存储过程

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