清华大佬耗费三个月吐血整理的几百G的资源,免费分享!....>>>
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 | DECLARE @procName VARCHAR (500) DECLARE cur CURSOR FOR SELECT [ name ] FROM sys.objects WHERE type = 'p' OPEN cur FETCH next FROM cur INTO @procName WHILE @@fetch_status = 0 BEGIN EXEC ( 'drop procedure ' + @procName) FETCH next FROM cur INTO @procName END CLOSE cur DEALLOCATE cur |