摘要: create table #tmp (name varchar(50),rows int,reserved varchar(50),data varchar(50),index_size varchar(50),unused varchar(50));insert into #tmp (name,rows,reserved,data,index_size,unused) exec sp_msforeachTable "sp_spaceused '?'"select *,--sum(convert(decimal,replace(reserved,' 阅读全文
posted @ 2012-02-16 09:22 张宏宇 阅读(223) 评论(0) 推荐(0) 编辑