set nocount on
if object_id(N'tempdb.db.#temp') is not null
drop table #temp
create table #temp (name sysname,count numeric(18))
insert into #temp
select o.name,i.rows
from sysobjects o,sysindexes i
where o.id=i.id and o.Xtype='U' and i.indid<2
select count(count) 总表数,sum(count) 总记录数 from #temp
select * from #temp order by count desc
set nocount off
if object_id(N'tempdb.db.#temp') is not null
drop table #temp
create table #temp (name sysname,count numeric(18))
insert into #temp
select o.name,i.rows
from sysobjects o,sysindexes i
where o.id=i.id and o.Xtype='U' and i.indid<2
select count(count) 总表数,sum(count) 总记录数 from #temp
select * from #temp order by count desc
set nocount off
转自:http://www.cnblogs.com/neekerss/archive/2011/03/24/1994005.html