SQL Server中删除以指定字符开头的存储过程

利用上面的代码可以轻松的删除数据库中以指定字符开头的存储过程。

create procedure dropproc(@bianliang varchar(100))
as
begin
declare @biao varchar(100),@sql varchar(1000)
set @sql='%'+@bianliang+'%'
declare c cursor for select name from sysobjects where type='P' and name like @sql
set @sql='drop Procedure '
open c
fetch c into @biao
while @@fetch_status=0
begin
     set @sql=@sql+@biao
     exec(@sql)
     set @sql='drop Procedure '
     fetch c into @biao 
end
close c
deallocate c
return
end