CREATE TABLE #T ([name] nvarchar(255),rows bigint)

DECLARE @Name nvarchar(255),@Sql nvarchar(4000)

DECLARE TName CURSOR FOR

SELECT [name] FROM sysobjects WHERE xtype = 'U'

OPEN TName

FETCH NEXT FROM TName INTO @Name

WHILE @@FETCH_STATUS = 0

BEGIN

    SET @Sql='INSERT INTO #T ([name],rows) SELECT '''+@name+''' AS name, COUNT(1) AS row FROM '+@name

    EXEC(@Sql)

    FETCH NEXT FROM TName INTO @name

END

CLOSE TName

DEALLOCATE TName

SELECT name '表名',rows '记录数' FROM #T order by rows desc