資料庫中所有表的行數

select a.name,b.rows from sysobjects a,sysindexes b
where a.id=b.id
and xtype='U' AND (b.indid IN (0, 1))-- and rows>=8575
order by b.rows desc