1.查看某个数据库中每个表的行数

SELECT
@@servername as servername,
db_name() as databasename,   
    s.name AS schemaname,
t.name AS tablename,
    p.rows AS rowcounts,
    SUM(a