sqlserver中按照表的大小进行排序
发布时间：2020-12-12 13:41:11 所属栏目：MsSql教程 来源：网络整理
导读：create?table?#lyf_Data(name?varchar(100),row?varchar(100),reserved?varchar(100),data?varchar(100),index_size?varchar(100),unused?varchar(100))?? ??????????????????????????????????????????????????????????????????????????????????????????????
|
create?table?#lyf_Data(name?varchar(100),row?varchar(100),reserved?varchar(100),data?varchar(100),index_size?varchar(100),unused?varchar(100))?? ????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????? declare?@name?varchar(100)?????????? declare?cur?cursor??for???????????? ????select?name?from?sysobjects?where?xtype='u'?order?by?name open?cur??????????????????????????? fetch?next?from?cur?into?@name????? while?@@fetch_status=0?????????????? begin?????????????????????????????? ????insert?into?#lyf_data?????????????? ????exec?sp_spaceused???@name??????? ????print?@name?????????????????? ????fetch?next?from?cur?into?@name? end?????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????? close?cur?????????????????????????? deallocate?cur???????????????? create?table?#lyf_DataNew(name?varchar(100),row?int,reserved?int,data?int,index_size?int,unused?int)????insert?into?#lyf_dataNew?????????????????????????????????????? select?name,convert(int,row)?as?row,replace(reserved,'KB',''))?as?reserved,replace(data,''))?as?data,??????? convert(int,replace(index_size,''))?as?index_size,replace(unused,''))?as?unused?from?#lyf_data????????????????? select?name,row,data/1024?as?data_size,index_size/1024?as?index_size?from?#lyf_dataNew?order?by?data?desc? drop?table?#lyf_data drop?table?#lyf_datanew
（编辑：李大同） 【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容! |