Goodspeed

导航

2007年12月28日 #

获取表的记录行数

摘要: 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 阅读(562) 评论(0) 推荐(0) 编辑