求一个求数据库中表的数据行数的sql？急，没分了

[hsie168518]

use pubs

select name from sysobjects where type='U'

得到数据
titleauthor
stores
sales
roysched
discounts
jobs
pub_info
employee
authors
publishers
titles

我想得到它们的实际数据条数

如

titleauthor 35
stores 40
sales 88
roysched
discounts
jobs
pub_info
employee
authors
publishers
titles

[中国风]

SELECT 
	a.name AS 表名,
	b.rows  AS AS 记录数
from sysobjects  AS a
	INNER JOIN sysindexes AS b ON a.ID=b.id AND b.indid<2
where a.type='U''