摘要： CREATE PROCEDURE dropProcedure AS declare cur cursor read_only for select name from sysobjects where xtype='p' and name like 'drop%' declare @name varchar(40),@sql varchar(1000) open cur fetch next from cur into @name while (@@fetch_status =0) begin set @sql ='drop Procedure ' 阅读全文