![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
或者使用我自己写的,不过只有行数,没有使用系统存储过程
1
declare @maxrowcount int
2
declare @maxtablename varchar(200)
3
declare @sql nvarchar(2000)
4
declare @tempcount int
5
set @sql = '';
6
set @maxtablename = '';
7
create table #rowcount
8
(counts int,tname varchar(200))
9
declare Tnamecursor cursor for select name from sysobjects where xtype = 'U' and OBJECTPROPERTY(id, N'IsUserTable') = 1
10
declare @name varchar(200);
11
open Tnamecursor
12
FETCH NEXT FROM Tnamecursor INTO @name
13
WHILE @@FETCH_STATUS = 0
14
BEGIN
15
set @sql = 'select @tempcount = count(*) from '+@name +' insert into #rowcount values (@tempcount,@name)';
16
print @sql
17
exec sp_executesql @sql,N'@tempcount int,@name varchar(200)',@tempcount,@name
18
--print @name+'total count:'+Convert(varchar(200),@tempcount)
19
if(@maxrowcount <@tempcount)
20
begin
21
set @maxrowcount = @tempcount;
22
set @maxtablename = @name;
23
end
24
FETCH NEXT FROM Tnamecursor INTO @name
25
end
26
CLOSE Tnamecursor
27
DEALLOCATE Tnamecursor
28![](/Images/OutliningIndicators/None.gif)
29
select * from #rowcount order by counts desc
30![](/Images/OutliningIndicators/None.gif)
31
drop table #rowcount
32![](/Images/OutliningIndicators/None.gif)
33![](/Images/OutliningIndicators/None.gif)
34![](/Images/OutliningIndicators/None.gif)
35![](/Images/OutliningIndicators/None.gif)
36![](/Images/OutliningIndicators/None.gif)
37![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
2
![](/Images/OutliningIndicators/None.gif)
3
![](/Images/OutliningIndicators/None.gif)
4
![](/Images/OutliningIndicators/None.gif)
5
![](/Images/OutliningIndicators/None.gif)
6
![](/Images/OutliningIndicators/None.gif)
7
![](/Images/OutliningIndicators/None.gif)
8
![](/Images/OutliningIndicators/None.gif)
9
![](/Images/OutliningIndicators/None.gif)
10
![](/Images/OutliningIndicators/None.gif)
11
![](/Images/OutliningIndicators/None.gif)
12
![](/Images/OutliningIndicators/None.gif)
13
![](/Images/OutliningIndicators/None.gif)
14
![](/Images/OutliningIndicators/None.gif)
15
![](/Images/OutliningIndicators/None.gif)
16
![](/Images/OutliningIndicators/None.gif)
17
![](/Images/OutliningIndicators/None.gif)
18
![](/Images/OutliningIndicators/None.gif)
19
![](/Images/OutliningIndicators/None.gif)
20
![](/Images/OutliningIndicators/None.gif)
21
![](/Images/OutliningIndicators/None.gif)
22
![](/Images/OutliningIndicators/None.gif)
23
![](/Images/OutliningIndicators/None.gif)
24
![](/Images/OutliningIndicators/None.gif)
25
![](/Images/OutliningIndicators/None.gif)
26
![](/Images/OutliningIndicators/None.gif)
27
![](/Images/OutliningIndicators/None.gif)
28
![](/Images/OutliningIndicators/None.gif)
29
![](/Images/OutliningIndicators/None.gif)
30
![](/Images/OutliningIndicators/None.gif)
31
![](/Images/OutliningIndicators/None.gif)
32
![](/Images/OutliningIndicators/None.gif)
33
![](/Images/OutliningIndicators/None.gif)
34
![](/Images/OutliningIndicators/None.gif)
35
![](/Images/OutliningIndicators/None.gif)
36
![](/Images/OutliningIndicators/None.gif)
37
![](/Images/OutliningIndicators/None.gif)