查询所有用户表的纪录数。
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
a.
name