快速获取表的行数

[sql]代码库

SELECT Sum(part.rows) row_count
FROM Sys.tables Tbl
INNER JOIN Sys.partitions Part ON Tbl.object_id = Part.object_id
INNER JOIN Sys.indexes Idx ON Part.object_id = Idx.object_id
	AND Part.index_id = Idx.index_id
WHERE Tbl.NAME = 'TableName'
	AND Idx.index_id < 2
GROUP BY Tbl.object_id
	,Tbl.NAME