[sqlserver]超大单表快速查询总行数(历史数据)

概述use [database]select schema_name(t.schema_id) as [Schema], t.name as TableName,i.rows as [RowCount]from sys.tables as t, sysindexes as iwhere t.object_id = i.id and i.indid <=1

use [database]select schema_name(t.schema_ID) as [Schema],t.name as tablename,i.rows as [RowCount]from sys.tables as t,sysindexes as iwhere t.object_ID = i.ID and i.indID <=1

总结

以上是内存溢出为你收集整理的[sqlserver]超大单表快速查询总行数(历史数据)全部内容，希望文章能够帮你解决[sqlserver]超大单表快速查询总行数(历史数据)所遇到的程序开发问题。

如果觉得内存溢出网站内容还不错，欢迎将内存溢出网站推荐给程序员好友。