|
马上注册,结交更多好友,享用更多功能,让你轻松玩转社区。
您需要 登录 才可以下载或查看,没有账号?注册账号
×
日志记录如下:
数据库名: UFDATA_001_2010
D:\U8SOFT\Admin\SQLFILE10000\Main\Ufdata\Structure\data_str_hy_mix_nl.sql
错误信息:
-2147217900
列名 'dopseq' 无效。
执行如下语句时出错:
ALTER VIEW [dbo].[HY_View_ListReport]
AS
select a.moCode,a.moSeq,a.MoStatus,a.dopseq as opseq,b.cCode,b.ddate,
a.InvCode,a.InvName,a.InvSpec,a.InvAddCode,
a.opcode as copcode,a.description,b.cdepcode,b.cdepname,b.cpersoncode,b.cpersonname,
b.cVenCode,b.cVenName,b.cvenabbName,convert(varchar(30),'') as itemClassCode,convert(varchar(30),'') as itemClassName,
convert(varchar(30),'') as itemCode,convert(varchar(30),'') as itemName,a.moDeptCode,a.ModeptName,
a.unitname as CINVM_UNIT,
b.define_1 as cdefine1,b.define_2 as cdefine2,b.define_3 as cdefine3,
b.define_4 as cdefine4,b.define_5 as cdefine5,b.define_6 as cdefine6,b.define_7 as cdefine7,
b.define_8 as cdefine8,b.define_9 as cdefine9,b.define_10 as cdefine10,b.define_11 as cdefine11,
b.define_12 as cdefine12,b.define_13 as cdefine13,b.define_14 as cdefine14,b.define_15 as cdefine15,
b.define_16 as cdefine16,a.define_22 as cdefine22,a.define_23 as cdefine23,
a.define_24 as cdefine24,a.define_25 as cdefine25,a.define_26 as cdefine26,
a.define_27 as cdefine27,a.define_28 as cdefine28,a.define_29 as cdefine29,
a.define_30 as cdefine30,a.define_31 as cdefine31,a.define_32 as cdefine32,
a.define_33 as cdefine33,a.define_34 as cdefine34,a.define_35 as cdefine35,
a.define_36 as cdefine36,a.define_37 as cdefine37,
a.InvFree_1 as cfree1,a.InvFree_2 as cfree2,a.InvFree_3 as cfree3,a.InvFree_4 as cfree4,a.InvFree_5 as cfree5,
a.InvFree_6 as cfree6,a.InvFree_7 as cfree7,a.InvFree_8 as cfree8,a.InvFree_9 as cfree9,a.InvFree_10 as cfree10,
Hy_ListReport.ID,cVoucherType,cBodyID,fQuantity,mReceiveMoney,mUsedvouchMoney,mPurbillMoney,
fJQuantity,mJMoney,fzQuantity,fzMoney,dRMonth,dUMonth,dPMonth ,b.cCreateUser,b.dCreatetime as dCreateDate,b.cModifyUser,
b.dModifyTime as dModifyDate,b.crelsUser,b.drelstime as drelsdate,qualifiedQty as fqualifiedQuantity,labScrapqty as fopScrapquantity ,matScrapQty as fmaScrapQuantity ,CONVERT(DECIMAL(38,10),NULL) as fInlostQuantity,ReworkQty as fRedoQuantity,
N'1' as CREDORESPONSE,b.ddate as accMonth,d1.cDepCode as cworkdepcode, d1.cdepname as cworkdepname,wcdesc as cworkcenter,hy_modetails.partid ,sfc_workcenter.wccode as wccode,vendor.iid as cvenauthid,inventory.iid as cinvauthid,
a.ReworkJFQty as fReworkJFQty ----added
,(CASE WHEN INO_ID>9999 THEN CAST(INO_ID AS NVARCHAR(10)) ELSE RIGHT('0000' +CAST(INO_ID AS NVARCHAR(10)),4) END) AS CPZCODE
from Hy_ListReport
LEFT JOIN GL_ACCVOUCH ON GL_ACCVOUCH.COUTNO_ID=HY_LISTREPORT.CPZID
left join v_hy_receivedetail a on a.receiveDId=Hy_ListReport.cBodyID
inner join hy_modetails on a.hydid = hy_modetails.AutoId
left join v_hy_receive b on a.receiveId=b.receiveId
left join sfc_workcenter on a.wcid=sfc_workcenter.wcid
left join department as d1 on d1.cdepcode=sfc_workcenter.DeptCode
left join vendor on vendor.cvencode=b.cvencode
left join inventory on inventory.cinvcode=a.invcode
where cVoucherType=N'收料单'
union
select
a.cMoordercode as moCode,a.imoorderseq as moSeq,md.status as MoStatus,sd.opseq,b.cCode,b.ddate,
a.cInvCode as invcode,a.cinvname as InvName,a.cinvstd as InvSpec,a.cinvaddcode as InvAddCode,
a.copcode as copcode,a.CDESCRIPTION as description,b.cdepcode,b.cdepname,b.cpersoncode,b.cpersonname,
b.cVenCode,b.cVenName,b.cvenabbName,convert(varchar(30),'') as itemClassCode,convert(varchar(30),'') as itemClassName,
convert(varchar(30),'') as itemCode,convert(varchar(30),'') as itemName,md.MDeptCode as moDeptCode,department.cdepname as ModeptName,
CCOMUNITNAME as CINVM_UNIT,
b.cdefine1 as cdefine1,b.cdefine2 as cdefine2,b.cdefine3 as cdefine3,
b.cdefine4 as cdefine4,b.cdefine5 as cdefine5,b.cdefine6 as cdefine6,b.cdefine7 as cdefine7,
b.cdefine8 as cdefine8,b.cdefine9 as cdefine9,b.cdefine10 as cdefine10,b.cdefine11 as cdefine11,
b.cdefine12 as cdefine12,b.cdefine13 as cdefine13,b.cdefine14 as cdefine14,b.cdefine15 as cdefine15,
b.cdefine16 as cdefine16,a.cdefine22 as cdefine22,a.cdefine23 as cdefine23,
a.cdefine24 as cdefine24,a.cdefine25 as cdefine25,a.cdefine26 as cdefine26,
a.cdefine27 as cdefine27,a.cdefine28 as cdefine28,a.cdefine29 as cdefine29,
a.cdefine30 as cdefine30,a.cdefine31 as cdefine31,a.cdefine32 as cdefine32,
a.cdefine33 as cdefine33,a.cdefine34 as cdefine34,a.cdefine35 as cdefine35,
a.cdefine36 as cdefine36,a.cdefine37 as cdefine37,
a.cfree1 as cfree1,a.cfree2 as cfree2,a.cfree3 as cfree3,a.cfree4 as cfree4,a.cfree5 as cfree5,
a.cfree6 as cfree6,a.cfree7 as cfree7,a.cfree8 as cfree8,a.cfree9 as cfree9,a.cfree10 as cfree10,
Hy_ListReport.ID,cVoucherType,cBodyID,fQuantity,mReceiveMoney,mUsedvouchMoney,mPurbillMoney,
fJQuantity,mJMoney,fzQuantity,fzMoney,dRMonth,dUMonth,dPMonth, b.cmaker as cCreateUser,b.dnmaketime as dCreateDate,b.cmodifier as cModifyUser,
b.dModifyDate,b.cverifier as crelsUser,b.dverifydate as drelsdate,CONVERT(DECIMAL(38,10),NULL) as fqualifiedQuantity,fopScrapquantity,fmaScrapQuantity,fInlostQuantity,fRedoQuantity,
convert(nvarchar(30),CREDORESPONSE)as CREDORESPONSE,b.ddate as accMonth,d1.cDepCode as cworkdepcode,d1.cdepname as cworkdepname,sfc_workcenter.Description as cworkcenter ,a.partid,sfc_workcenter.wccode as wccode,b.cvenauthid as cvenauthid,a.cinvauthid as cinvauthid,
CONVERT(DECIMAL(38,10),NULL) as fReworkJFQty ---added
,(CASE WHEN INO_ID>9999 THEN CAST(INO_ID AS NVARCHAR(10)) ELSE RIGHT('0000' +CAST(INO_ID AS NVARCHAR(10)),4) END) AS CPZCODE
from Hy_ListReport
LEFT JOIN GL_ACCVOUCH ON GL_ACCVOUCH.COUTNO_ID=HY_LISTREPORT.CPZID
left join HYSCRAPREPORTBODY a on a.autoid=Hy_ListReport.cBodyID
left join sfc_moroutingdetail sd on a.isourceautoid= sd.moroutingdid
left join sfc_workcenter on sd.wcid=sfc_workcenter.wcid
left join HYSCRAPREPORTHEAD b on a.id=b.id
left join mom_orderdetail md on md.modid= sd.modid
left join department on department.cdepcode=md.MDeptCode
left join department as d1 on d1.cdepcode=sfc_workcenter.DeptCode
where cVoucherType=N'不良品报告单'
union
select a.cMoordercode as moCode,a.imoorderseq as moSeq,md.status as MoStatus,a.opseq,b.cCode,b.ddate,
a.cInvCode as invcode,a.cinvname as InvName,a.cinvstd as InvSpec,a.cinvaddcode as InvAddCode,
a.copcode,a.cdescription as description,b.cdepcode,b.cdepname,b.cpersoncode,b.cpersonname,
b.cVenCode,b.cVenName,b.cvenabbName,convert(varchar(30),'') as itemClassCode,convert(varchar(30),'') as itemClassName,
convert(varchar(30),'') as itemCode,convert(varchar(30),'') as itemName,md.MDeptCode as moDeptCode,department.cdepname as ModeptName,
CINVM_UNIT,
b.cdefine1 as cdefine1,b.cdefine2 as cdefine2,b.cdefine3 as cdefine3,
b.cdefine4 as cdefine4,b.cdefine5 as cdefine5,b.cdefine6 as cdefine6,b.cdefine7 as cdefine7,
b.cdefine8 as cdefine8,b.cdefine9 as cdefine9,b.cdefine10 as cdefine10,b.cdefine11 as cdefine11,
b.cdefine12 as cdefine12,b.cdefine13 as cdefine13,b.cdefine14 as cdefine14,b.cdefine15 as cdefine15,
b.cdefine16 as cdefine16,a.cdefine22 as cdefine22,a.cdefine23 as cdefine23,
a.cdefine24 as cdefine24,a.cdefine25 as cdefine25,a.cdefine26 as cdefine26,
a.cdefine27 as cdefine27,a.cdefine28 as cdefine28,a.cdefine29 as cdefine29,
a.cdefine30 as cdefine30,a.cdefine31 as cdefine31,a.cdefine32 as cdefine32,
a.cdefine33 as cdefine33,a.cdefine34 as cdefine34,a.cdefine35 as cdefine35,
a.cdefine36 as cdefine36,a.cdefine37 as cdefine37,
a.cfree1 as cfree1,a.cfree2 as cfree2,a.cfree3 as cfree3,a.cfree4 as cfree4,a.cfree5 as cfree5,
a.cfree6 as cfree6,a.cfree7 as cfree7,a.cfree8 as cfree8,a.cfree9 as cfree9,a.cfree10 as cfree10,
Hy_ListReport.ID,cVoucherType,cBodyID,fQuantity,mReceiveMoney,mUsedvouchMoney,mPurbillMoney,
fJQuantity,mJMoney,fzQuantity,fzMoney,dRMonth,dUMonth,dPMonth, b.cmaker as cCreateUser,b.ddate as dCreateDate,b.cmodifier as cModifyUser,
b.dModifyDate,b.cverifier as crelsUser,b.dverifydate as drelsdate,a.fvalidquantity as fqualifiedQuantity,a.fopScrapquantity,a.fmaScrapQuantity,a.fInlostQuantity,CONVERT(DECIMAL(38,10),NULL) as fRedoQuantity,
convert(varchar(30),'') as CREDORESPONSE,b.ddate as accMonth,d1.cDepCode as cworkdepcode,d1.cdepname as cworkdepname,sfc_workcenter.Description as cworkcenter ,a.partid,sfc_workcenter.wccode as wccode,b.cvenauthid as cvenauthid,a.cinvauthid as cinvauthid,
a.FREWORKJFQTY as fReworkJFQty ---added
,(CASE WHEN INO_ID>9999 THEN CAST(INO_ID AS NVARCHAR(10)) ELSE RIGHT('0000' +CAST(INO_ID AS NVARCHAR(10)),4) END) AS CPZCODE
from Hy_ListReport
LEFT JOIN GL_ACCVOUCH ON GL_ACCVOUCH.COUTNO_ID=HY_LISTREPORT.CPZID
left join HY_USEDBODY a on a.autoid=Hy_ListReport.cBodyID
left join HY_USEDHEAD b on a.id=b.id
left join hy_modetails on a.ihyorderdid =hy_modetails.autoid
left join mom_order on a.cmoordercode =mom_order.mocode
left join mom_orderdetail md on mom_order.moid=md.moid and a.imoorderseq=md.sortseq
--有可能存在对应的挂账单 无对应的加工单的情况
--left join sfc_moroutingdetail sd on hy_modetails.isourceautoid =sd.moroutingdid
left join sfc_moroutingdetail sd on md.modid =sd.modid and a.opseq=sd.opseq
left join sfc_workcenter on sd.wcid=sfc_workcenter.wcid
left join department on department.cdepcode=md.MDeptCode
left join department as d1 on d1.cdepcode=sfc_workcenter.DeptCode
where cVoucherType=N'挂账单'
union
select hy_usedvouchs.cmoordercode as moCode,hy_usedvouchs.imoorderseq as moSeq,md.status as MoStatus,a.opseq,b.cpbvcode as cCode,b.DPBVDATE as ddate,
a.cInvCode as invcode,a.cinvname as InvName,a.cinvstd as InvSpec,a.cinvaddcode as InvAddCode,
a.copcode,a.cdescription as description,b.cdepcode,b.cdepname,b.cpersoncode,b.cpersonname,
b.cVenCode,b.cVenName,b.cvenabbName,convert(varchar(30),'') as itemClassCode,convert(varchar(30),'') as itemClassName,
convert(varchar(30),'') as itemCode,convert(varchar(30),'') as itemName,md.MDeptCode as moDeptCode,department.cdepname as ModeptName,
CINVM_UNIT,
b.cdefine1 as cdefine1,b.cdefine2 as cdefine2,b.cdefine3 as cdefine3,
b.cdefine4 as cdefine4,b.cdefine5 as cdefine5,b.cdefine6 as cdefine6,b.cdefine7 as cdefine7,
b.cdefine8 as cdefine8,b.cdefine9 as cdefine9,b.cdefine10 as cdefine10,b.cdefine11 as cdefine11,
b.cdefine12 as cdefine12,b.cdefine13 as cdefine13,b.cdefine14 as cdefine14,b.cdefine15 as cdefine15,
b.cdefine16 as cdefine16,a.cdefine22 as cdefine22,a.cdefine23 as cdefine23,
a.cdefine24 as cdefine24,a.cdefine25 as cdefine25,a.cdefine26 as cdefine26,
a.cdefine27 as cdefine27,a.cdefine28 as cdefine28,a.cdefine29 as cdefine29,
a.cdefine30 as cdefine30,a.cdefine31 as cdefine31,a.cdefine32 as cdefine32,
a.cdefine33 as cdefine33,a.cdefine34 as cdefine34,a.cdefine35 as cdefine35,
a.cdefine36 as cdefine36,a.cdefine37 as cdefine37,
a.cfree1 as cfree1,a.cfree2 as cfree2,a.cfree3 as cfree3,a.cfree4 as cfree4,a.cfree5 as cfree5,
a.cfree6 as cfree6,a.cfree7 as cfree7,a.cfree8 as cfree8,a.cfree9 as cfree9,a.cfree10 as cfree10,
Hy_ListReport.ID,cVoucherType,cBodyID,fQuantity,mReceiveMoney,mUsedvouchMoney,mPurbillMoney,
fJQuantity,mJMoney,fzQuantity,fzMoney,dRMonth,dUMonth,dPMonth, b.cpbvmaker as cCreateUser,b.dpbvdate as dCreateDate,b.creviser as cModifyUser,
b.cModifyDate as dModifyDate,convert(varchar(30),'') as crelsUser,'' as drelsdate,CONVERT(DECIMAL(38,10),NULL) as fqualifiedQuantity,CONVERT(DECIMAL(38,10),NULL) as fopScrapquantity ,CONVERT(DECIMAL(38,10),NULL) as fmaScrapQuantity,
CONVERT(DECIMAL(38,10),NULL)as fInlostQuantity,CONVERT(DECIMAL(38,10),NULL) as fRedoQuantity,
convert(varchar(30),'') as CREDORESPONSE,dPBVdate as accMonth,d1.cDepCode as cworkdepcode, d1.cdepname as cworkdepname,sfc_workcenter.Description as cworkcenter,hy_usedvouchs.partid as partid,sfc_workcenter.wccode as wccode,b.cvenauthid as cvenauthid,a.cinvauthid as cinvauthid,
CONVERT(DECIMAL(38,10),NULL) as fReworkJFQty ---added
,(CASE WHEN INO_ID>9999 THEN CAST(INO_ID AS NVARCHAR(10)) ELSE RIGHT('0000' +CAST(INO_ID AS NVARCHAR(10)),4) END) AS CPZCODE
from Hy_ListReport
LEFT JOIN GL_ACCVOUCH ON GL_ACCVOUCH.COUTNO_ID=HY_LISTREPORT.CPZID
left join HY_BILLBODY a on a.id=Hy_ListReport.cBodyID
left join HY_BILLHEAD b on a.PBVID=b.PBVID
left join hy_usedvouchs on a.rdsid=hy_usedvouchs.autoid
left join hy_modetails on a.ihyorderdid =hy_modetails.autoid
left join mom_order on hy_usedvouchs.cmoordercode =mom_order.mocode
left join mom_orderdetail md on mom_order.moid=md.moid and hy_usedvouchs.imoorderseq=md.sortseq
--有可能存在对应的挂账单 无对应的加工单的情况
--left join sfc_moroutingdetail sd on hy_modetails.isourceautoid =sd.moroutingdid
left join sfc_moroutingdetail sd on md.modid =sd.modid and a.opseq=sd.opseq
left join sfc_workcenter on sd.wcid=sfc_workcenter.wcid
left join department on department.cdepcode=md.MDeptCode
left join department as d1 on d1.cdepcode=sfc_workcenter.DeptCode
where cVoucherType=N'发票'
效率测试报告:开始升级UFDATA_001_2010数据库
data_str_pb_wfmodel_nl.SQL,2012-2-28 16:09:57 -- 2012-2-28 16:10:03,0小时0分钟6秒。
data_str_pb_mommodel_nl.SQL,2012-2-28 16:10:03 -- 2012-2-28 16:10:06,0小时0分钟3秒。
data_str_pb_portalmodel_nl.SQL,2012-2-28 16:10:06 -- 2012-2-28 16:10:10,0小时0分钟4秒。
data_str_pb_ufsubmodel_nl.SQL,2012-2-28 16:10:10 -- 2012-2-28 16:10:10,0小时0分钟0秒。
Data_STR_PB_DR_NL.SQL,2012-2-28 16:10:10 -- 2012-2-28 16:10:11,0小时0分钟1秒。
Data_STR_PB_mix_NL.SQL,2012-2-28 16:10:11 -- 2012-2-28 16:10:15,0小时0分钟4秒。
Data_STR_PB_Vou_NL.SQL,2012-2-28 16:10:15 -- 2012-2-28 16:10:15,0小时0分钟0秒。
data_str_pb_uap_nl.SQL,2012-2-28 16:10:15 -- 2012-2-28 16:10:15,0小时0分钟0秒。
data_str_pb_as_nl.SQL,2012-2-28 16:10:15 -- 2012-2-28 16:10:27,0小时0分钟12秒。
data_str_pb_start_nl.SQL,2012-2-28 16:10:27 -- 2012-2-28 16:10:27,0小时0分钟0秒。
data_str_pb_dae_nl.SQL,2012-2-28 16:10:27 -- 2012-2-28 16:10:27,0小时0分钟0秒。
workflow_str_pb_mix_nl.SQL,2012-2-28 16:10:27 -- 2012-2-28 16:10:27,0小时0分钟0秒。
Data_STR_SR_mix_NL.SQL,2012-2-28 16:10:27 -- 2012-2-28 16:10:30,0小时0分钟3秒。
data_str_rt_mix_nl.SQL,2012-2-28 16:10:30 -- 2012-2-28 16:10:30,0小时0分钟0秒。
data_str_ss_mix_nl.SQL,2012-2-28 16:10:30 -- 2012-2-28 16:10:30,0小时0分钟0秒。
data_str_wa_mix_nl.SQL,2012-2-28 16:10:30 -- 2012-2-28 16:10:35,0小时0分钟5秒。
Data_STR_HR_TM_mix_NL.SQL,2012-2-28 16:10:35 -- 2012-2-28 16:10:40,0小时0分钟5秒。
Data_STR_HR_TR_mix_NL.SQL,2012-2-28 16:10:40 -- 2012-2-28 16:10:40,0小时0分钟0秒。
data_str_ht_mix_nl.SQL,2012-2-28 16:10:40 -- 2012-2-28 16:10:40,0小时0分钟0秒。
data_str_pr_mix_nl.SQL,2012-2-28 16:10:40 -- 2012-2-28 16:10:41,0小时0分钟1秒。
data_str_pf_mix_nl.SQL,2012-2-28 16:10:41 -- 2012-2-28 16:10:56,0小时0分钟15秒。
data_str_hb_mix_nl.SQL,2012-2-28 16:10:56 -- 2012-2-28 16:10:57,0小时0分钟1秒。
data_str_hm_mix_nl.SQL,2012-2-28 16:10:57 -- 2012-2-28 16:10:57,0小时0分钟0秒。
data_str_wm_mix_nl.SQL,2012-2-28 16:10:57 -- 2012-2-28 16:10:57,0小时0分钟0秒。
data_str_sg_mix_nl.SQL,2012-2-28 16:10:57 -- 2012-2-28 16:11:01,0小时0分钟4秒。
data_str_wh_mix_nl.SQL,2012-2-28 16:11:01 -- 2012-2-28 16:11:01,0小时0分钟0秒。
DATA_STR_FA_MIX_NL.SQL,2012-2-28 16:11:01 -- 2012-2-28 16:11:17,0小时0分钟16秒。
Data_STR_CM_mix_NL.SQL,2012-2-28 16:11:17 -- 2012-2-28 16:11:20,0小时0分钟3秒。
Data_STR_FD_mix_NL.SQL,2012-2-28 16:11:20 -- 2012-2-28 16:11:22,0小时0分钟2秒。
data_str_ed_mix_nl.SQL,2012-2-28 16:11:22 -- 2012-2-28 16:11:53,0小时0分钟31秒。
Data_STR_EQ_mix_NL.SQL,2012-2-28 16:11:53 -- 2012-2-28 16:11:58,0小时0分钟5秒。
Data_STR_NE_mix_NL.SQL,2012-2-28 16:11:58 -- 2012-2-28 16:11:59,0小时0分钟1秒。
Data_STR_NB_Mix_NL.SQL,2012-2-28 16:11:59 -- 2012-2-28 16:12:00,0小时0分钟1秒。
Data_STR_PM_mix_NL.SQL,2012-2-28 16:12:00 -- 2012-2-28 16:12:09,0小时0分钟9秒。
DATA_STR_BG_MIX_NL.SQL,2012-2-28 16:12:09 -- 2012-2-28 16:12:27,0小时0分钟18秒。
Data_STR_FM_mix_NL.SQL,2012-2-28 16:12:27 -- 2012-2-28 16:12:28,0小时0分钟1秒。
Data_STR_GL_mix_NL.SQL,2012-2-28 16:12:28 -- 2012-2-28 16:12:39,0小时0分钟11秒。
data_str_gf_mix_nl.SQL,2012-2-28 16:12:39 -- 2012-2-28 16:12:39,0小时0分钟0秒。
Data_STR_CA_mix_NL.SQL,2012-2-28 16:12:39 -- 2012-2-28 16:13:16,0小时0分钟37秒。
Data_STR_AP_mix_NL.SQL,2012-2-28 16:13:16 -- 2012-2-28 16:13:26,0小时0分钟10秒。
data_str_sc_mix_nl.SQL,2012-2-28 16:13:26 -- 2012-2-28 16:13:26,0小时0分钟0秒。
Data_STR_EX_mix_NL.SQL,2012-2-28 16:13:26 -- 2012-2-28 16:13:41,0小时0分钟15秒。
Data_STR_IM_mix_NL.SQL,2012-2-28 16:13:41 -- 2012-2-28 16:13:44,0小时0分钟3秒。
data_str_sa_mix_nl.SQL,2012-2-28 16:13:44 -- 2012-2-28 16:13:55,0小时0分钟11秒。
Data_STR_ST_mix_NL.SQL,2012-2-28 16:13:55 -- 2012-2-28 16:14:13,0小时0分钟18秒。
Data_STR_PU_mix_NL.SQL,2012-2-28 16:14:13 -- 2012-2-28 16:14:21,0小时0分钟8秒。
data_str_scm_mix_nl.SQL,2012-2-28 16:14:21 -- 2012-2-28 16:14:21,0小时0分钟0秒。
Data_STR_QM_mix_NL.SQL,2012-2-28 16:14:21 -- 2012-2-28 16:14:25,0小时0分钟4秒。
Data_STR_IA_mix_NL.SQL,2012-2-28 16:14:25 -- 2012-2-28 16:14:34,0小时0分钟9秒。
Data_STR_OM_mix_NL.SQL,2012-2-28 16:14:34 -- 2012-2-28 16:14:35,0小时0分钟1秒。
DATA_STR_PA_MIX_NL.SQL,2012-2-28 16:14:35 -- 2012-2-28 16:14:35,0小时0分钟0秒。
升级起始时间:2012-2-28 16:09:56,结束时间:2012-2-28 16:14:49,0小时4分钟53秒。
|
|