查询数据库的所有表的记录数

select a.name, b.rows 
from sysobjects a
inner join sysindexes b on a.id = b.id
where a.type = 'u'
and b.indid in (0, 1)
order by a.name