---获取数据库中每个表的行数 declare @sql nvarchar(max) set @sql='' select @sql=@sql+'select '''+cast(name as varchar(50))+''' as tablename, count(*) as rows from ' + name+ ' union all ' from sysobjects where xtype= 'u ' select @sql= left(@sql,len(@sql)-15) +' order by rows desc ' exec (@sql)