批量处理的代码如下：
DECLARE cursorname cursor for select 'drop PROCEDURE '+name from sysobjects where name like 'xx%' and xtype = 'p'--删除对应的存储过程
DECLARE cursorname cursor for select 'drop table '+name from sysobjects where name like 'xx%' and xtype = 'u'--删除对应的表
open cursorname
declare @curname sysname
fetch next from cursorname into @curname
while(@@fetch_status=0)
begin
exec(@curname)
fetch next from cursorname into @curname
end
close cursorname
deallocate cursorname