用友T6软件数据库压力过大,发生并发冲突
技术咨询,有偿服务!
复制微信号
数据库压力过大,发生并发冲突
原因分析:请在查询分析器里对该账套执行下列脚本----采购建临时表出现并发错误--Add by wangjw 2007-3-27--Reason:并发重途If Exists(select * from sysobjects where [name]='PU_CreateTemp_PurPzTmp' and xtype='p') Drop procedure PU_CreateTemp_PurPzTmpGo Create procedure PU_CreateTemp_PurPzTmp as set nocount on Begin Transaction IF NOT EXISTS (SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 'PurPzTmp') CREATE TABLE PurPzTmp(cWhCode varchar(255),id int,sId int, rdId int, blID int,typeId int, coutaccset varchar(255),iOutYear int,coutsysname varchar(255),coutsysver varchar(10), doutbilldate DateTime, iOutPeriod smallint,coutsign varchar(10),cOutNo_id varchar(255), doutdate DateTime,coutbillsign varchar(255),cOutid varchar(20),cSign varchar(255),cbill varchar(255), cdigest varchar(255),cCode varchar(255),md float,md_f float,mc float,mc_f float,nd_s float, cexch_name varchar(10),nfrat float,cdept_id varchar(20),cperson_id varchar(20),cSup_id varchar(60),c
问题解答:请在查询分析器里对该账套执行下列脚本----采购建临时表出现并发错误--Add by wangjw 2007-3-27--Reason:并发重途If Exists(select * from sysobjects where [name]='PU_CreateTemp_PurPzTmp' and xtype='p') Drop procedure PU_CreateTemp_PurPzTmpGo Create procedure PU_CreateTemp_PurPzTmp as set nocount on Begin Transaction IF NOT EXISTS (SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 'PurPzTmp') CREATE TABLE PurPzTmp(cWhCode varchar(255),id int,sId int, rdId int, blID int,typeId int, coutaccset varchar(255),iOutYear int,coutsysname varchar(255),coutsysver varchar(10), doutbilldate DateTime, iOutPeriod smallint,coutsign varchar(10),cOutNo_id varchar(255), doutdate DateTime,coutbillsign varchar(255),cOutid varchar(20),cSign varchar(255),cbill varchar(255), cdigest varchar(255),cCode varchar(255),md float,md_f float,mc float,mc_f float,nd_s float, cexch_name varchar(10),nfrat float,cdept_id varchar(20),cperson_id varchar(20),cSup_id varchar(60),citem_id varchar(60), citem_class varchar(255),cname varchar(40), bVouchedit bit DEFAULT 0,bvouchAddordele bit DEFAULT 0,bvouchmoneyhold bit DEFAULT 0,bvalueedit bit DEFAULT 0, bcodeedit bit DEFAULT 0,ccodecontrol varchar(255),bPCSedit bit DEFAULT 0,bDeptedit bit DEFAULT 0,bitemedit bit DEFAULT 0, bCusSupInput bit DEFAULT 0) If @@error!=0 Rollback Commit TransactionGo
如果您的问题还没有解决,或者在百度上找不到答案可以到右上角搜索中进行搜索。