34,593
社区成员
发帖
与我相关
我的任务
分享
/********清除表.数据********/
declare @sql varchar(1000)
declare @i int
declare @table varchar(300)
set @i = 1
select * into #temp from sysobjects where type='U'
select @i=count(*) from #temp
while @i > 0
begin
select top 1 @table = name from #temp order by name
set @sql = 'delete from '+@table
delete #temp where name = @table
select @i=count(*) from #temp
exec (@sql)
end
drop table #temp