SQL2000数据库表数据量大小查询方法详解

如何查看SQL2000数据库中所有表的数据量大小

只需直接在查询分析器中运行即可：declare@idintdeclare@typecharacter(2)declare@pagesintdeclare@dbnamesysnamedeclare@dbsizeddec(15,0)declare@bytesperpagedec(15,0)declare@pagesperMBdec(15,0)createtable#spt_space(objidint_space)(objidint_space)，行intnull,reserveddec(15)null,datadec(15)null,indexpdec(15)null,unseddec(15)null)setnocounton--通过usertablesdeclarec_tablescursorforselectidfromsysobjectswherextype='U'openc_tablesf创建cursorto循环etcnextfromc_tablesinto@idwhile@@fetch_status=0begin/*Codefromsp_spaceused*/insertinto#spt_space(objid,reserved)selectobjid=@id,sum(reserved)fromsysindexeswhereindidin(0,1,255)andid=@sumidselect@pagesges)fromsysindexeswhereindid

sql查询数据表后在统计某一列数据不重复的数量

1.r2(200)，

Goodmodelvarchar2(200)、Workidvarchar2(200)、Goodnamevarchar2(200))；

2.

insertintotest_SalesStatistics

select'name_'||(level/4),

level/4,

sysdate-level,

级别/10，

级别/100，

级别/8，

'好'||(级别/4

>来自dual

connectbylevel<10000>

,

Goodname,

Goodmodel,

SUM(Order_Quantity)ASOrder_Quantity，

Workid

FROM(selectGoods_Name,

Order_Quantity,

Delivery_Date,

Store_Abbreviation;

>

Goodmodel，

Workid，

Goodname

fromtest_SalesStatistics

quibus_char(Delivery_Date)在“19980810”和“20000810”之间

GROUPBYStore_Abbreviation、Goodmodel、Work、好名字

4.金额，

selectcount(distinctStore_Abbreviation)Store_Abbreviation，

计数(distinctGoodmodel)Goodmodel，

计数(distinctWorkid)工作，

计数(distinctGoodname)Goodname

fromTEST_MIDt;