win2008服务器运行慢,用友T310.8plus2支持win2008服务器系统吗？怎么反应运行慢啊...

解决方案:从别的帐套中导出此视图覆盖坏的帐套，或执行语句

SET QUOTED_IDENTIFIER OFF

GO

SET ANSI_NULLS ON

GO

CREATE view dbo.recordoutlist

as

select dbo.recordoutq.id, dbo.recordoutq.brdflag, dbo.recordoutq.cvouchtype,

dbo.recordoutq.cwhcode, dbo.recordoutq.ddate, dbo.recordoutq.ccode,

dbo.recordoutq.crdcode, dbo.recordoutq.cdepcode, dbo.recordoutq.imquantity,

dbo.recordoutq.cpersoncode, dbo.recordoutq.cprobatch, dbo.recordoutq.bpufirst, dbo.recordoutq.biafirst,

dbo.recordoutq.chandler, dbo.recordoutq.cmemo, dbo.recordoutq.caccounter,

dbo.recordoutq.cmaker, dbo.recordoutq.cdefine1, dbo.recordoutq.cdefine2,

dbo.recordoutq.cdefine3, dbo.recordoutq.cdefine4, dbo.recordoutq.cdefine5,

dbo.recordoutq.cdefine6, dbo.recordoutq.cdefine7, dbo.recordoutq.cdefine8,

dbo.recordoutq.cdefine9, dbo.recordoutq.cdefine10, dbo.recordoutq.cwhname,

dbo.recordoutq.cdepname, dbo.recordoutq.cpersonname, dbo.recordoutq.cinvname as cinvname_1,

dbo.recordoutq.ufts,

dbo.recordoutq.crdname, dbo.recordoutq.csource, dbo.recordoutq.cbustype,

dbo.recordoutq.cpspcode,dbo.recordoutq.cmpocode,

dbo.recordoutq.ipurorderid, dbo.recordoutq.ipurarriveid, dbo.recordoutq.iproorderid,

dbo.recordoutq.iarriveid,dbo.recordoutq.isalebillid,

dbo.recordoutsq.autoid, dbo.recordoutsq.id as id_1, dbo.recordoutsq.cinvcode,

dbo.recordoutsq.cinvaddcode, dbo.recordoutsq.cinvname,

dbo.recordoutsq.cinvstd, dbo.recordoutsq.cinvm_unit,

dbo.recordoutsq.cinva_unit, dbo.recordoutsq.creplaceitem,

dbo.recordoutsq.cposition, dbo.recordoutsq.cinvdefine1,

dbo.recordoutsq.cinvdefine2, dbo.recordoutsq.cinvdefine3,

dbo.recordoutsq.cfree1, dbo.recordoutsq.cfree2, dbo.recordoutsq.cbatch,

dbo.recordoutsq.iinvexchrate, dbo.recordoutsq.inum, dbo.recordoutsq.iquantity,

dbo.recordoutsq.iunitcost, round(dbo.recordoutsq.iprice,2) as iprice, dbo.recordoutsq.ipunitcost,

round(dbo.recordoutsq.ipprice,2) as ipprice, dbo.recordoutsq.dvdate, dbo.recordoutsq.cobjcode,

dbo.recordoutsq.isoutquantity, dbo.recordoutsq.isoutnum,

dbo.recordoutsq.dsdate, dbo.recordoutsq.ifquantity, dbo.recordoutsq.ifnum,

dbo.recordoutsq.cvouchcode, dbo.recordoutq.cbuscode,

dbo.recordoutsq.cdefine22, dbo.recordoutsq.cdefine23,

dbo.recordoutsq.cdefine24, dbo.recordoutsq.cdefine25,

dbo.recordoutsq.cdefine26, dbo.recordoutsq.cdefine27,

dbo.recordoutsq.citemcode, dbo.recordoutsq.citem_class,

dbo.recordoutq.dveridate, dbo.recordoutsq.cname, dbo.recordoutsq.citemcname,

dbo.recordoutq.darvdate, dbo.recordoutq.cchkcode, dbo.recordoutq.dchkdate,

dbo.recordoutq.cchkperson, dbo.recordoutq.bisstqc, dbo.recordoutq.vt_id,

dbo.recordoutq.cdefine11, dbo.recordoutq.cdefine12, dbo.recordoutq.cdefine13,

dbo.recordoutq.cdefine14, dbo.recordoutq.cdefine15, dbo.recordoutq.cdefine16,

dbo.recordoutq.imquantity as expr1, dbo.recordoutsq.cinvdefine4,

dbo.recordoutsq.cinvdefine5, dbo.recordoutsq.cinvdefine6,

dbo.recordoutsq.cinvdefine7, dbo.recordoutsq.cinvdefine8,

dbo.recordoutsq.cinvdefine9, dbo.recordoutsq.cinvdefine10,

dbo.recordoutsq.cinvdefine11, dbo.recordoutsq.cinvdefine12,

dbo.recordoutsq.cinvdefine13, dbo.recordoutsq.cinvdefine14,

dbo.recordoutsq.cinvdefine15, dbo.recordoutsq.cinvdefine16, dbo.recordoutsq.iid,

dbo.recordoutsq.cfree3, dbo.recordoutsq.cfree4, dbo.recordoutsq.cfree5,

dbo.recordoutsq.cfree6, dbo.recordoutsq.cfree7, dbo.recordoutsq.cfree8,

dbo.recordoutsq.cfree9, dbo.recordoutsq.cfree10, dbo.recordoutsq.cbarcode,

dbo.recordoutsq.inquantity, dbo.recordoutsq.innum, dbo.recordoutsq.cassunit,

dbo.recordoutsq.dmadedate, dbo.recordoutsq.cdefine28,

dbo.recordoutsq.cdefine29, dbo.recordoutsq.cdefine30,

dbo.recordoutsq.cdefine31, dbo.recordoutsq.cdefine32,

dbo.recordoutsq.cdefine33, dbo.recordoutsq.cdefine34,

dbo.recordoutsq.cdefine35, dbo.recordoutsq.cdefine36,

dbo.recordoutsq.cdefine37, dbo.recordoutsq.impoids, dbo.recordoutsq.icheckids,

dbo.recordoutsq.cbvencode, dbo.recordoutsq.cvenname,

dbo.recordoutsq.cinvouchcode, dbo.recordoutsq.imassdate,

dbo.recordoutsq.cposname

from dbo.recordoutq left outer join

dbo.recordoutsq on dbo.recordoutq.id = dbo.recordoutsq.id

GO

SET QUOTED_IDENTIFIER OFF

GO

SET ANSI_NULLS ON

GO

温馨提示：如果您的问题还没有解决，欢迎进入