储存过程

删除储存过程

DECLARE @STRING VARCHAR(8000)
WHILE EXISTS(SELECT NAME FROM SYSOBJECTS WHERE TYPE='P' AND STATUS>=0)
BEGIN
 SELECT @STRING='DROP  PROCEDURE '+NAME  FROM   SYSOBJECTS    WHERE   TYPE = 'P' AND STATUS>=0
 --SELECT @STRING
 EXEC(@STRING)
END