MS SQL 查看一个数据库中所有表的行数

SELECT   a.name, b.rows
FROM      sysobjects AS a INNER JOIN
                sysindexes AS b ON a.id = b.id
WHERE   (a.type = 'u') AND (b.indid IN (0, 1))
ORDER BY b.rows DESC