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

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

 

 
--批量删除数据库表数据
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