Đếm số dòng của bảng

SELECT tbl.name AS TableName,
       TableRowCount =
       (
           SELECT SUM(spart.rows)
           FROM sys.partitions spart
           WHERE spart.object_id = tbl.object_id
                 AND spart.index_id < 2
       )
FROM sys.tables tbl
WHERE tbl.name <> 'sysdiagrams'
	AND (tbl.name LIKE N'B30%' OR
		tbl.name IN ('B20Customer','B20Dept','B20Employee','B20ExpenseCatg','B20Warehouse','B20Item','B20ItemInfo','B20ItemUnit','B20ItemGroup','B20Product','B20Unit','B20Asset','B20BankAccount','B20VoucherRegister','B20InBotMapData')
	)
	AND (
				SELECT SUM(spart.rows)
				FROM sys.partitions spart
				WHERE spart.object_id = tbl.object_id
					AND spart.index_id < 2
		) <> 0
ORDER BY tbl.name ASC;