|
|
楼主 |
发表于 2015-5-5 08:43:37
|
显示全部楼层
(SELECT t.sID, t.SLASTMODIFYTIME AS sLastModifyTime, t.SPROCESSTEMPLATEITEMSEQUENCE AS sProcessTemplateItemSequence, t.SEXECUTETIME AS sExecuteTime, t.SENFIELD11 AS sENField11, t.SEXECUTORDEPTID AS sExecutorDeptID, t.SENFIELD12 AS sENField12, t.SCREATORDEPTID AS sCreatorDeptID, t.SFLOWID AS sFlowID, t.SPROCESS AS
sProcess, t.SFRONTID AS sFrontID, t.SESFIELD06 AS sESField06, t.SESFIELD05 AS sESField05, t.SCREATETIME AS sCreateTime, t.SESFIELD04 AS sESField04, t.SESFIELD03 AS sESField03, t.SESFIELD02 AS sESField02, t.SESFIELD01 AS sESField01, t.SACTIVITYINTEMPLATE AS sActivityInTemplate, t.SEXPECTSTARTTIME AS
sExpectStartTime, t.SCREATORFID AS sCreatorFID, t.sParentID AS sParent, t.SEXPECTFINISHTIME AS sExpectFinishTime, t.SCREATORPOSNAME AS sCreatorPosName, t.SPROJECTNAME AS sProjectName, t.SSTATUSID AS sStatusID, t.SESFIELD07 AS sESField07, t.SCREATORDEPTNAME AS sCreatorDeptName, t.SESFIELD08 AS sESField08,
t.SIMPORTANCEID AS sImportanceID, t.SSTATUSNAME AS sStatusName, t.SPLANNAME AS sPlanName, t.SACTIVITYNAMES AS sActivityNames, t.SEXECUTORFID AS sExecutorFID, t.SVARIABLE AS sVariable, t.SENFIELD14 AS sENField14, t.SENFIELD13 AS sENField13, t.SCREATOROGNNAME AS sCreatorOgnName, t.SRESPONSIBLE AS sResponsible,
t.SAISTATUSNAME AS sAIStatusName, t.SEXECUTOROGNID AS sExecutorOgnID, t.SWITHDRAW AS sWithdraw, t.SPROCESSTEMPLATEID AS sProcessTemplateID, t.VERSION AS version, t.SEXECUTORDEPTNAME AS sExecutorDeptName, t.SLIMITTIME AS sLimitTime, t.STEMPPERMISSIONID AS sTempPermissionID, t.SPROJECTID AS sProjectID, t.SSOURCEID
AS sSourceID, t.SPREEMPTMODE AS sPreemptMode, t.SIMPORTANCENAME AS sImportanceName, t.SEURL AS sEURL, t.SEXECUTORNAMES AS sExecutorNames, t.SDATA3 AS sData3, t.SDATA4 AS sData4, t.SDATA1 AS sData1, t.SDATA2 AS sData2, t.SACTIVE AS sActive, t.SSUMMARY AS sSummary, t.SETFIELD33 AS sETField33, t.SETFIELD34 AS
sETField34, t.SLOCK AS sLock, t.SETFIELD31 AS sETField31, t.SEXECUTORPOSID AS sExecutorPosID, t.SCUSTOMERNAME AS sCustomerName, t.SETFIELD32 AS sETField32, t.SKINDID AS sKindID, t.SEDFIELD23 AS sEDField23, t.SEDFIELD22 AS sEDField22, t.SEDFIELD24 AS sEDField24, t.SREMINDMODE AS sRemindMode, t.SCREATORFNAME AS sCreatorFName, t.SPROCESSTEMPLATEID2 AS sProcessTemplateID2, t.SCUSTOMERID AS sCustomerID, t.SEXECUTORPOSNAME AS sExecutorPosName, t.SSHORTCUT AS sShortcut, t.SEDFIELD21 AS sEDField21, t.SEXECUTEMODE AS sExecuteMode, t.SPROCESSNAME AS sProcessName, t.SWARNINGTIME AS sWarningTime, t.SEBFIELD51 AS sEBField51, t.SEBFIELD52 AS sEBField52, t.SEBFIELD53 AS sEBField53, t.SEBFIELD54 AS sEBField54, t.SCREATORPERSONNAME AS sCreatorPersonName, t.SEIFIELD44 AS sEIField44, t.SEXECUTOROGNNAME AS sExecutorOgnName, t.SEIFIELD43 AS sEIField43, t.SEIFIELD42 AS sEIField42, t.SEIFIELD41 AS sEIField41, t.SDISTRIBUTETIME AS sDistributeTime, t.SCONTENT AS sContent, t.STYPENAME AS sTypeName, t.SAISTATUSID AS sAIStatusID, t.SACTUALSTARTTIME AS sActualStartTime, t.SEMERGENCYID AS sEmergencyID, t.SCREATORPERSONID AS sCreatorPersonID, t.SCURL AS sCURL, t.SCATALOGID AS sCatalogID, t.SSEQUENCE AS sSequence, t.SEXECUTORPERSONID AS sExecutorPersonID, t.SAIID AS sAIID, t.SAIACTIVE AS sAIActive, t.SACTIVITY AS sActivity, t.SCREATORPOSID AS sCreatorPosID, t.SCREATOROGNID AS sCreatorOgnID, t.STYPEID AS sTypeID, t.SEMERGENCYNAME AS sEmergencyName, t.SREMARK AS sRemark, t.SCODE AS sCode, t.SACTIVITYNAME AS sActivityName, t.SPLANID AS sPlanID, t.SEXECUTEMODE2 AS sExecuteMode2, t.SEXECUTORFNAME AS sExecutorFName, t.SACTUALFINISHTIME AS sActualFinishTime, t.SHINTS AS sHints, t.SEXECUTORPERSONNAME AS sExecutorPersonName, t.SNAME AS sName FROM SA_Task t WHERE t.SFLOWID = @P0 )
找到了 这段SQL导致死锁 然后怎么处理？ |
|
IP卡
狗仔卡
发表于 2015-4-29 17:40:01
显身卡
