清空数据库里所有的表的数据
use 你要清空的库godeclare @tbname varchar(250)declare #tb cursor for select name from sysobjects where objectproperty(id,IsUserTable)=1open #tbfetch next from #tb into @tbnamewhile @@fetch_status=0begin
·
use 你要清空的库
go
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 from ['+@tbname+']')
fetch next from #tb into @tbname
end
close #tb
deallocate #tb
更多推荐



所有评论(0)