SQL Server中查询数据库中每一张表的记录数

SELECT CAST(NULL AS sysname) AS 表名称, 1 AS 记录数 INTO #table WHERE 1 = 0DECLARE @TableName sysnameDECLARE testcur CURSOR FOR SELECT [name] FROM sysobjects WHERE xtype ='U' ORDER BY [name]OPEN testcurFETCH NEXT FROM testcur INTO @TableNameWHILE @@fetch_status = 0BEGIN    EXEC('INSERT INTO #table SELECT ''' + @TableName + ''', (SELECT COUNT(1) FROM ' + @TableName + ')')    FETCH NEXT FROM testcur INTO @TableNameENDCLOSE testcurDEALLOCATE testcurSELECT * from #tableDROP TABLE #table