批量删除数据库表数据 备份

批量删除数据库表数据  备份

 

     
  
-- 
  批量删除数据库表数据 
  
 
  declare  
  @tbname  
  varchar( 
  250) 
  
declare #tb  
  cursor  
  for  
  select name  
  from sysobjects  
  where  
  objectproperty(id, 
  ' 
  IsUserTable 
  ') 
  = 
  1 
  
open #tb 
  
fetch  
  next  
  from #tb  
  into  
  @tbname 
  
while  
  @@fetch_status 
  = 
  0 
  
begin 
  
   
  exec( 
  ' 
  delete  [ 
  ' 
  + 
  @tbname 
  + 
  ' 
  ] 
  ') 
  
   
  fetch  
  next  
  from #tb  
  into  
  @tbname 
  
end 
  
close #tb 
    
 

deallocate #tb