use northwindcreate table tb (tablename varchar(50),counnumber int)insert into tb exec sp_msforeachtable 'select ''?'',count(*) from ?'select top 1 tablename,counnumber from tb
order by counnumber descdrop table tb结果
tablename counnumber
-------------------------------------------------- -----------
[dbo].[Order Details] 2145(1 row(s) affected)
order by counnumber descdrop table tb结果
tablename counnumber
-------------------------------------------------- -----------
[dbo].[Order Details] 2145(1 row(s) affected)
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货