查看数据库中每张表的总记录数

话不多说！直接上代码

declare @table_name varchar(1000),@sql varchar(1000)
 IF (OBJECT_ID('tempdb..#tmp_master') IS NOT NULL)
DROP TABLE #tmp_master
create table #tmp_master
(num bigint,table_name varchar(1000))
 DECLARE cur_trans CURSOR LOCAL STATIC READ_ONLY FORWARD_ONLY
    FOR
        SELECT  name FROM sysobjects where xtype = 'U' order by name;
    OPEN cur_trans;
    FETCH NEXT FROM cur_trans INTO @table_name;
    WHILE @@FETCH_STATUS = 0
        BEGIN                   
           set @sql = 'insert into #tmp_master (num,table_name) select count(1),table_name = '''+@table_name+''' from ' + @table_name
            exec(@sql)   
            FETCH NEXT FROM cur_trans INTO @table_name;
        END;
    CLOSE cur_trans;
    DEALLOCATE cur_trans;
select  * from #tmp_master