--> 测试数据:@t declare @t table( id int identity(1,1), name nvarchar(200), rows int, reserved nvarchar(200), data nvarchar(200), index_size nvarchar(200), unused nvarchar(200) ) insert into @t EXEC sp_MSforeachtable "EXECUTE sp_spaceused '?'"select * from @t order by rows desc select top 5 * from @t order by rows desc
declare @t table(
id int identity(1,1),
name nvarchar(200),
rows int,
reserved nvarchar(200),
data nvarchar(200),
index_size nvarchar(200),
unused nvarchar(200)
)
insert into @t EXEC sp_MSforeachtable "EXECUTE sp_spaceused '?'"select * from @t order by rows desc
select top 5 * from @t order by rows desc