SQL 备忘录（SQL SERVER）

1.获取数据库中各表的记录数

SELECT A.NAME AS 表名,MAX(B.ROWS) AS 记录条数
  FROM SYSOBJECTS A, SYSINDEXES B
 WHERE A.ID = B.ID
   AND A.XTYPE = 'U'
 GROUP BY A.NAME
 ORDER BY MAX(B.ROWS) DESC;