use [$DB] go declare @tabSize table(name nvarchar(100),rows char(20),reserved varchar(18) ,data varchar(18) ,index_size varchar(18) ,nnused varchar(18) ) insert into @tabSize exec sp_msforeachtable 'sp_spaceused ''?''' select * from @tabSize order by convert(int,replace(data,'KB','')) desc,2 desc
sqlserver查询数据库表的大小 有排序
最新推荐文章于 2024-08-23 14:12:39 发布