34,588
社区成员
发帖
与我相关
我的任务
分享
SELECT row_number() over(order by name) id,Name into #t FROM SysObjects Where XType='U' ORDER BY Name
declare @i int,@count int
set @i = 1
select @count = count(1) from #t
declare @sql varchar(200),@tname varchar(50)
while @i <= @count
begin
select @tname = name from #t where id = @i
set @sql = 'truncate table ' + @tname
print @sql
set @i = @i + 1
end
SELECT row_number() over(order by name) id,Name into #t FROM SysObjects Where XType='U' ORDER BY Name
declare @i int,@count int
set @i = 1
select @count = count(1) from #t
declare @sql varchar(200),@tname varchar(50)
while @i <= @count
begin
select @tname = name from #t where id = @i
set @sql = 'select * into [' + @tname +'] from ' + @tname + ' where 1 = 2'
print @sql
set @i = @i + 1
end
drop table #t