Question

如何用SQL语句查询数据库中有内容的表名?

例如:DB1 包含10个表 其中有记录的只有表1和表2,
我希望能显示这两个表名

Answer 1

declare @tb varchar(32)
declare c1 cursor for
select name from sysobjects
where type='u'
open c1
fetch next from c1 into @tb
while @@fetch_status = 0
begin
declare @i int
declare @sql nvarchar(3000)
set @sql=N'select @b=count(*) from '+ @tb
exec sp_executesql @sql,N'@b int output',@b=@i output
if @i>0
print @tb
fetch next from c1 into @tb
end
close c1
deallocate c1