DECLARE @STRING VARCHAR(8000)
WHILE EXISTS(SELECT NAME FROM SYSOBJECTS WHERE TYPE='P' AND STATUS>=0)
BEGIN
SELECT TOP 1 @STRING='DROP PROCEDURE '+ NAME FROM SYSOBJECTS WHERE TYPE = 'P' AND STATUS>=0
--SELECT @STRING
exec(@STRING)
END
GO
SQL Server 删除所有存储过程
最新推荐文章于 2024-01-14 09:00:00 发布