SQLServer 查询用户表记录数SQL

 

查询统计用户表的记录数大小的常用SQL

 

SELECT    a.name,   b.rows   FROM   sysobjects(NOLOCK)    as  a   

JOIN   sysindexes(NOLOCK)  as b   ON   b.id   =   a.id   

WHERE   a.xtype   =   'U '   AND   b.indid   IN   (0,   1)   ORDER   By   b.rows  DESC

 

查询单个表记录数

 

SELECT   a.name,   b.rows   FROM   sysobjects   a   WITH(NOLOCK)   

JOIN   sysindexes   b   WITH(NOLOCK)   ON   b.id   =   a.id   

WHERE   a.id   =   object_id( 'table_name')   and   a.xtype   =   'U '   AND   b.indid   IN   (0,   1)   

ORDER   By   a.name   ASC