sql语句-快速查看sqlserver表记录数

快速查找用户表记录数

 

SELECT   a.name,   b.rows   FROM   sysobjects   a   WITH(NOLOCK)   JOIN   sysindexes   b   WITH(NOLOCK)   ON   b.id   =   a.id   WHERE   a.xtype   =   'U '   AND   b.indid   IN   (0,   1)   ORDER   By   a.name   ASC 

快速查找用户表记录数——单个表

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( '表名 ')   and   a.xtype   =   'U '   AND   b.indid   IN   (0,   1)   ORDER   By   a.name   ASC 

sp_spaceused 表