sql server 2000中如何查询数据库中哪个表行数最多?

方法一：create proc ssasset nocount oncreate table TableSpace( TableName varchar(50), RowsCount char(11), Reserved varchar(18), Data varchar(18), Index_size varchar(18), Unused varchar(18) )declare @sql varchar(500)declare @TableName varchar(50)declare Cursor1 Cursorfor select name from sysobjects where xtype='U'open Cursor1fetch next from Cursor1 into @TableNamewhile @@fetch_status = 0begin set @sql = 'insert into TableSpace ' set @sql = @sql + ' exec sp_spaceused '''+ @TableName + ''' ' exec (@sql) fetch next from Cursor1 into @TableNameendclose Cursor1deallocate Cursor1select tableName,rowscount from TableSpace where tableName<>'TableSpace'order by rowscountdrop table TableSpacegoexec ss方法二：select 表名=a.name,记录数=b.rows from sysobjects a,sysindexes bwhere a.name=b.name and a.type='u'order by =b.rows 参考资料： 收起