删除存储过程 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