04 2013 档案

查询一个数据库中所有表的记录数
摘要：with TableRecord(TableName,RecordCount) as( select o.name,i.rows from sysobjects o,sysindexes i where o.id=i.id and o.Xtype='U' and i.indid<2 ) select * from TableRecord order by tablename 阅读全文
posted @ 2013-04-11 14:37 夕阳茶 阅读(242) 评论(0) 推荐(0)