查看表的行数

查看一个表的行数:

sp_spaceused InstitutionClinicaltrials

查看一个数据库中所有表的行数:

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 b.rows DESC