用SqlServer系统表快速统计表的总行数

 

 

1  -- Sql Server 统计表行数--
2  SELECT   o.NAME,i.rowcnt
3  FROM  sysindexes  AS  i 
4  INNER   JOIN  sysobjects  AS  o  ON  i.id  =  o.id 
5  WHERE  i.indid  <   2   and  o.xtype  =   ' U '
6  ORDER   BY  o.NAME

 

转载于:https://www.cnblogs.com/caizhiyuan/archive/2011/04/05/2006056.html