获取表的记录行数
摘要:
SELECT t.name,p.rows FROM sys.indexes AS iINNER JOIN sys.tables AS t ON i.object_id = t.object_idjoin sys.partitions p with(nolock) on i.object_id = p.object_id AND i.index_id = p.index_idWHERE i.type... 阅读全文
posted @ 2007-12-28 15:26 Goodspeed 阅读(564) 评论(0) 推荐(0) 编辑