批量删除某类数据表

declare @name varchar(30);
declare cur cursor for 
    select name from sysobjects where xtype='U' and name like 'temp_%';
open cur;
while 1=1 begin
    fetch next from cur into @name;
    if(@@fetch_status = -1)
        break;
    exec('delete from dbo.'+@name);
    print @name;
end;
close cur;
deallocate cur;

删除以"temp_"开头的数据表。