如何用SQL语句，查出数据库中所有记录为空的表？

[qwerttyy]

RT

谢谢～

[crazyflower]

create table ttt
(
aa nvarchar(50)
)
declare @TableName nvarchar(50)
declare cursor_1 cursor for select name from sysobjects where xtype='U'
open cursor_1
fetch next from cursor_1 into @TableName
while @@fetch_status=0
begin
exec ('if (select count(*) from '+@TableName+')=0 insert into ttt values ('''+@TableName+''')')
fetch next from cursor_1 into @TableName
end
select * from ttt
drop table ttt
close cursor_1
deallocate cursor_1

[qwerttyy]

找到方法了，不用这么麻烦

select sysobjects.name,rows from sysobjects,sysindexes where sysobjects.name=sysindexes.name and xtype='u' and rows=0

[greenberet007]

学习

[shanglivv7713]

呵呵!快给分吧