select name ,记录数 from
(
select s.name,
(select rowcnt from sysindexes where id=s.id and status=0 )as 记录数
from sysobjects s where xtype='U'
) s2 where s2.记录数>0
select name ,记录数 from
(
select s.name,
(select rowcnt from sysindexes where id=s.id and status=0 )as 记录数
from sysobjects s where xtype='U'
) s2 where s2.记录数>0