thdaymoneynull,zhynchar(10)null)createtableZC(IDnchar(20)notnull,Namenchar(15)notnull,b_Datenchar(15)notnull,Typenchar(15)null,mentnchar(50)null)3.视图useFcManagegocreateviewzzcasselectSUM(Amount)as'总支出'fromZC,YHBWHEREYHB.ID=ZC.IDuseFcManagegocreateviewzsrasselectSUM(Amount)as'总收入'fromSR,YHBWHEREYHB.ID=SR.IDuseFcManagegocreateviewYEasselect总收入-总支出as'余额'fromzzc,zsruseFcManagegocreateviewYHSRasselectYHB.ID,YHB.Name,SR.b_Date,SR.Type,SR.Amount,mentfromYHB,SRWHEREYHB.ID=SR.IDuseFcManagegocreateviewYHZCasselectYHB.ID,YHB.Name,ZC.b_Date,ZC.Type,ZC.Amount,mentfromYHB,ZCWHEREYHB.ID=ZC.ID4.索引UseFcManagegocreateindexaaonSR(b_Date)UseFcManagegocreateindexbbonZC(b_Date)5.存储UseFcManagegocreateproceduregetSRdata(@IDnchar(20),@Namenchar(15),@b_Datenchar(15),@Typenchar(15),@Amountmoney,@Commentnchar(50)=’无’
全文预览
