/**查看每个表的行数,不需要去COUNT(1)去查询原表**/
SELECT a.name, b.rows
FROM sysobjects AS a INNER JOIN sysindexes AS b ON a.id = b.id
WHERE (a.type = 'u') AND (b.indid IN (0, 1))
ORDER BY a.name,b.rows DESC
这种情况查询到的数据,是未提交读
/**查看每个表的行数,不需要去COUNT(1)去查询原表**/
SELECT a.name, b.rows
FROM sysobjects AS a INNER JOIN sysindexes AS b ON a.id = b.id
WHERE (a.type = 'u') AND (b.indid IN (0, 1))
ORDER BY a.name,b.rows DESC
这种情况查询到的数据,是未提交读