查看SqlServer中各表的记录条数
摘要:
select a.name as 表,max(b.rows) as 记录 from sysobjects a ,sysindexes b where a.id=b.id and a.xtype='u' group by a.name order by max(b.rows) desc 阅读全文
posted @ 2010-05-22 23:41 龙少爷 阅读(525) 评论(0) 推荐(0) 编辑