2025-12-08 17:07:31 执行时长：7.41秒 sql:DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCerti' and keyvalue in (select id from  GB_ProjectPlanCerti where ProjectNo = N'20997-2025-QEO-E') delete from  GB_ProjectPlanCerti where ProjectNo = N'20997-2025-QEO-E' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCerti' and keyvalue in (select id from  GB_ProjectPlanCerti where ProjectNo = N'20997-2025-QEO-E') delete from  GB_ProjectPlanCerti where ProjectNo = N'20997-2025-QEO-E' DELETE FROM base_bizColumnattach WHERE accesspath='GB_CertiDoc' and keyvalue in (select id from  GB_CertiDoc where ProjectNo = N'20997-2025-QEO-E') delete from  GB_CertiDoc where ProjectNo = N'20997-2025-QEO-E' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanEnergy' and keyvalue in (select id from  GB_ProjectPlanEnergy where PlanNo = N'20997-2025-QEO-E-100') delete from  GB_ProjectPlanEnergy where PlanNo = N'20997-2025-QEO-E-100' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from  GB_ProjectPlanTeam where TaskNo = N'2cd6265ff5164a1fb709cec29f7cbf07') delete from  GB_ProjectPlanTeam where TaskNo = N'2cd6265ff5164a1fb709cec29f7cbf07' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'2cd6265ff5164a1fb709cec29f7cbf07') delete from  GB_ProjectPlanCombine where TaskNo = N'2cd6265ff5164a1fb709cec29f7cbf07' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'2cd6265ff5164a1fb709cec29f7cbf07') delete from  GB_ProjectPlanCombine where TaskNo = N'2cd6265ff5164a1fb709cec29f7cbf07' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'2cd6265ff5164a1fb709cec29f7cbf07') delete from  GB_ProjectPlanCombine where TaskNo = N'2cd6265ff5164a1fb709cec29f7cbf07' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'2cd6265ff5164a1fb709cec29f7cbf07') delete from  GB_ProjectPlanCombine where TaskNo = N'2cd6265ff5164a1fb709cec29f7cbf07' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'2cd6265ff5164a1fb709cec29f7cbf07') delete from  GB_ProjectPlanCombine where TaskNo = N'2cd6265ff5164a1fb709cec29f7cbf07' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from  GB_ProjectPlanTeam where TaskNo = N'2cd6265ff5164a1fb709cec29f7cbf07') delete from  GB_ProjectPlanTeam where TaskNo = N'2cd6265ff5164a1fb709cec29f7cbf07' DELETE FROM base_bizColumnattach WHERE accesspath='GB_AuditProblem' and keyvalue in (select id from  GB_AuditProblem where TaskNo = N'2cd6265ff5164a1fb709cec29f7cbf07') delete from  GB_AuditProblem where TaskNo = N'2cd6265ff5164a1fb709cec29f7cbf07' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'2cd6265ff5164a1fb709cec29f7cbf07') delete from  GB_ProjectPlanCombine where TaskNo = N'2cd6265ff5164a1fb709cec29f7cbf07' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from  GB_ProjectPlanTeam where TaskNo = N'2cd6265ff5164a1fb709cec29f7cbf07') delete from  GB_ProjectPlanTeam where TaskNo = N'2cd6265ff5164a1fb709cec29f7cbf07' DELETE FROM base_bizColumnattach WHERE accesspath='GB_AuditProblem' and keyvalue in (select id from  GB_AuditProblem where TaskNo = N'2cd6265ff5164a1fb709cec29f7cbf07') delete from  GB_AuditProblem where TaskNo = N'2cd6265ff5164a1fb709cec29f7cbf07' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'2cd6265ff5164a1fb709cec29f7cbf07') delete from  GB_ProjectPlanCombine where TaskNo = N'2cd6265ff5164a1fb709cec29f7cbf07' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from  GB_ProjectPlanTeam where TaskNo = N'2cd6265ff5164a1fb709cec29f7cbf07') delete from  GB_ProjectPlanTeam where TaskNo = N'2cd6265ff5164a1fb709cec29f7cbf07' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'2cd6265ff5164a1fb709cec29f7cbf07') delete from  GB_ProjectPlanCombine where TaskNo = N'2cd6265ff5164a1fb709cec29f7cbf07' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'2cd6265ff5164a1fb709cec29f7cbf07') delete from  GB_ProjectPlanCombine where TaskNo = N'2cd6265ff5164a1fb709cec29f7cbf07' DELETE FROM base_bizColumnattach WHERE accesspath='GB_InvalidDoc' and keyvalue in (select id from  GB_InvalidDoc where TaskNo = N'2cd6265ff5164a1fb709cec29f7cbf07') delete from  GB_InvalidDoc where TaskNo = N'2cd6265ff5164a1fb709cec29f7cbf07' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from  GB_ProjectPlanTeam where TaskNo = N'2cd6265ff5164a1fb709cec29f7cbf07') delete from  GB_ProjectPlanTeam where TaskNo = N'2cd6265ff5164a1fb709cec29f7cbf07' DELETE FROM base_bizColumnattach WHERE accesspath='GB_AuditorContactRecord' and keyvalue in (select id from  GB_AuditorContactRecord where TaskNo = N'2cd6265ff5164a1fb709cec29f7cbf07') delete from  GB_AuditorContactRecord where TaskNo = N'2cd6265ff5164a1fb709cec29f7cbf07' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'2cd6265ff5164a1fb709cec29f7cbf07') delete from  GB_ProjectPlanCombine where TaskNo = N'2cd6265ff5164a1fb709cec29f7cbf07' DELETE FROM base_bizColumnattach WHERE accesspath='GB_AuditProblem' and keyvalue in (select id from  GB_AuditProblem where TaskNo = N'2cd6265ff5164a1fb709cec29f7cbf07') delete from  GB_AuditProblem where TaskNo = N'2cd6265ff5164a1fb709cec29f7cbf07' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from  GB_ProjectPlanTeam where TaskNo = N'2cd6265ff5164a1fb709cec29f7cbf07') delete from  GB_ProjectPlanTeam where TaskNo = N'2cd6265ff5164a1fb709cec29f7cbf07' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'2cd6265ff5164a1fb709cec29f7cbf07') delete from  GB_ProjectPlanCombine where TaskNo = N'2cd6265ff5164a1fb709cec29f7cbf07' DELETE FROM base_bizColumnattach WHERE accesspath='GB_AuditorContactRecord' and keyvalue in (select id from  GB_AuditorContactRecord where TaskNo = N'2cd6265ff5164a1fb709cec29f7cbf07') delete from  GB_AuditorContactRecord where TaskNo = N'2cd6265ff5164a1fb709cec29f7cbf07' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'2cd6265ff5164a1fb709cec29f7cbf07') delete from  GB_ProjectPlanCombine where TaskNo = N'2cd6265ff5164a1fb709cec29f7cbf07' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from  GB_ProjectPlanTeam where TaskNo = N'2cd6265ff5164a1fb709cec29f7cbf07') delete from  GB_ProjectPlanTeam where TaskNo = N'2cd6265ff5164a1fb709cec29f7cbf07' DELETE FROM GB_ProjectPlan WHERE ID='512000769' DELETE FROM base_bizattach WHERE bizentityid='003002' and keyvalue='512000769' DELETE FROM base_bizColumnattach WHERE bizentityid='003002' and keyvalue='512000769' DELETE FROM base_bizattach WHERE bizentityid='008001' and keyvalue='512000769' DELETE FROM base_bizColumnattach WHERE bizentityid='008001' and keyvalue='512000769' DELETE FROM base_bizattach WHERE bizentityid='003003' and keyvalue='512000769' DELETE FROM base_bizColumnattach WHERE bizentityid='003003' and keyvalue='512000769' DELETE FROM base_bizattach WHERE bizentityid='003004' and keyvalue='512000769' DELETE FROM base_bizColumnattach WHERE bizentityid='003004' and keyvalue='512000769' DELETE FROM base_bizattach WHERE bizentityid='003005' and keyvalue='512000769' DELETE FROM base_bizColumnattach WHERE bizentityid='003005' and keyvalue='512000769' DELETE FROM base_bizattach WHERE bizentityid='006001' and keyvalue='512000769' DELETE FROM base_bizColumnattach WHERE bizentityid='006001' and keyvalue='512000769' DELETE FROM base_bizattach WHERE bizentityid='006002' and keyvalue='512000769' DELETE FROM base_bizColumnattach WHERE bizentityid='006002' and keyvalue='512000769' DELETE FROM base_bizattach WHERE bizentityid='006003' and keyvalue='512000769' DELETE FROM base_bizColumnattach WHERE bizentityid='006003' and keyvalue='512000769' DELETE FROM base_bizattach WHERE bizentityid='004003' and keyvalue='512000769' DELETE FROM base_bizColumnattach WHERE bizentityid='004003' and keyvalue='512000769' DELETE FROM base_bizattach WHERE bizentityid='004004' and keyvalue='512000769' DELETE FROM base_bizColumnattach WHERE bizentityid='004004' and keyvalue='512000769' DELETE FROM base_bizattach WHERE bizentityid='008002' and keyvalue='512000769' DELETE FROM base_bizColumnattach WHERE bizentityid='008002' and keyvalue='512000769' DELETE FROM base_bizattach WHERE bizentityid='003006' and keyvalue='512000769' DELETE FROM base_bizColumnattach WHERE bizentityid='003006' and keyvalue='512000769' DELETE FROM base_bizattach WHERE bizentityid='001035001' and keyvalue='512000769' DELETE FROM base_bizColumnattach WHERE bizentityid='001035001' and keyvalue='512000769' DELETE FROM base_bizattach WHERE bizentityid='003025' and keyvalue='512000769' DELETE FROM base_bizColumnattach WHERE bizentityid='003025' and keyvalue='512000769' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='003002' and rowid='512000769') DELETE FROM wf_workflowinstance where bizentityid='003002' and rowid='512000769' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='008001' and rowid='512000769') DELETE FROM wf_workflowinstance where bizentityid='008001' and rowid='512000769' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='003003' and rowid='512000769') DELETE FROM wf_workflowinstance where bizentityid='003003' and rowid='512000769' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='003004' and rowid='512000769') DELETE FROM wf_workflowinstance where bizentityid='003004' and rowid='512000769' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='003005' and rowid='512000769') DELETE FROM wf_workflowinstance where bizentityid='003005' and rowid='512000769' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='006001' and rowid='512000769') DELETE FROM wf_workflowinstance where bizentityid='006001' and rowid='512000769' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='006002' and rowid='512000769') DELETE FROM wf_workflowinstance where bizentityid='006002' and rowid='512000769' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='006003' and rowid='512000769') DELETE FROM wf_workflowinstance where bizentityid='006003' and rowid='512000769' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='004003' and rowid='512000769') DELETE FROM wf_workflowinstance where bizentityid='004003' and rowid='512000769' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='004004' and rowid='512000769') DELETE FROM wf_workflowinstance where bizentityid='004004' and rowid='512000769' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='008002' and rowid='512000769') DELETE FROM wf_workflowinstance where bizentityid='008002' and rowid='512000769' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='003006' and rowid='512000769') DELETE FROM wf_workflowinstance where bizentityid='003006' and rowid='512000769' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='001035001' and rowid='512000769') DELETE FROM wf_workflowinstance where bizentityid='001035001' and rowid='512000769' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='003025' and rowid='512000769') DELETE FROM wf_workflowinstance where bizentityid='003025' and rowid='512000769' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='003002' and rowid='512000769') DELETE FROM wf_bizflowinstance where bizentityid='003002' and rowid='512000769' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='008001' and rowid='512000769') DELETE FROM wf_bizflowinstance where bizentityid='008001' and rowid='512000769' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='003003' and rowid='512000769') DELETE FROM wf_bizflowinstance where bizentityid='003003' and rowid='512000769' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='003004' and rowid='512000769') DELETE FROM wf_bizflowinstance where bizentityid='003004' and rowid='512000769' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='003005' and rowid='512000769') DELETE FROM wf_bizflowinstance where bizentityid='003005' and rowid='512000769' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='006001' and rowid='512000769') DELETE FROM wf_bizflowinstance where bizentityid='006001' and rowid='512000769' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='006002' and rowid='512000769') DELETE FROM wf_bizflowinstance where bizentityid='006002' and rowid='512000769' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='006003' and rowid='512000769') DELETE FROM wf_bizflowinstance where bizentityid='006003' and rowid='512000769' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='004003' and rowid='512000769') DELETE FROM wf_bizflowinstance where bizentityid='004003' and rowid='512000769' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='004004' and rowid='512000769') DELETE FROM wf_bizflowinstance where bizentityid='004004' and rowid='512000769' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='008002' and rowid='512000769') DELETE FROM wf_bizflowinstance where bizentityid='008002' and rowid='512000769' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='003006' and rowid='512000769') DELETE FROM wf_bizflowinstance where bizentityid='003006' and rowid='512000769' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='001035001' and rowid='512000769') DELETE FROM wf_bizflowinstance where bizentityid='001035001' and rowid='512000769' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='003025' and rowid='512000769') DELETE FROM wf_bizflowinstance where bizentityid='003025' and rowid='512000769'

2025-12-08 17:07:38 执行时长：7.09秒 sql:DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCerti' and keyvalue in (select id from  GB_ProjectPlanCerti where ProjectNo = N'20997-2025-QEO-Q') delete from  GB_ProjectPlanCerti where ProjectNo = N'20997-2025-QEO-Q' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCerti' and keyvalue in (select id from  GB_ProjectPlanCerti where ProjectNo = N'20997-2025-QEO-Q') delete from  GB_ProjectPlanCerti where ProjectNo = N'20997-2025-QEO-Q' DELETE FROM base_bizColumnattach WHERE accesspath='GB_CertiDoc' and keyvalue in (select id from  GB_CertiDoc where ProjectNo = N'20997-2025-QEO-Q') delete from  GB_CertiDoc where ProjectNo = N'20997-2025-QEO-Q' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanEnergy' and keyvalue in (select id from  GB_ProjectPlanEnergy where PlanNo = N'20997-2025-QEO-Q-100') delete from  GB_ProjectPlanEnergy where PlanNo = N'20997-2025-QEO-Q-100' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from  GB_ProjectPlanTeam where TaskNo = N'2cd6265ff5164a1fb709cec29f7cbf07') delete from  GB_ProjectPlanTeam where TaskNo = N'2cd6265ff5164a1fb709cec29f7cbf07' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'2cd6265ff5164a1fb709cec29f7cbf07') delete from  GB_ProjectPlanCombine where TaskNo = N'2cd6265ff5164a1fb709cec29f7cbf07' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'2cd6265ff5164a1fb709cec29f7cbf07') delete from  GB_ProjectPlanCombine where TaskNo = N'2cd6265ff5164a1fb709cec29f7cbf07' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'2cd6265ff5164a1fb709cec29f7cbf07') delete from  GB_ProjectPlanCombine where TaskNo = N'2cd6265ff5164a1fb709cec29f7cbf07' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'2cd6265ff5164a1fb709cec29f7cbf07') delete from  GB_ProjectPlanCombine where TaskNo = N'2cd6265ff5164a1fb709cec29f7cbf07' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'2cd6265ff5164a1fb709cec29f7cbf07') delete from  GB_ProjectPlanCombine where TaskNo = N'2cd6265ff5164a1fb709cec29f7cbf07' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from  GB_ProjectPlanTeam where TaskNo = N'2cd6265ff5164a1fb709cec29f7cbf07') delete from  GB_ProjectPlanTeam where TaskNo = N'2cd6265ff5164a1fb709cec29f7cbf07' DELETE FROM base_bizColumnattach WHERE accesspath='GB_AuditProblem' and keyvalue in (select id from  GB_AuditProblem where TaskNo = N'2cd6265ff5164a1fb709cec29f7cbf07') delete from  GB_AuditProblem where TaskNo = N'2cd6265ff5164a1fb709cec29f7cbf07' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'2cd6265ff5164a1fb709cec29f7cbf07') delete from  GB_ProjectPlanCombine where TaskNo = N'2cd6265ff5164a1fb709cec29f7cbf07' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from  GB_ProjectPlanTeam where TaskNo = N'2cd6265ff5164a1fb709cec29f7cbf07') delete from  GB_ProjectPlanTeam where TaskNo = N'2cd6265ff5164a1fb709cec29f7cbf07' DELETE FROM base_bizColumnattach WHERE accesspath='GB_AuditProblem' and keyvalue in (select id from  GB_AuditProblem where TaskNo = N'2cd6265ff5164a1fb709cec29f7cbf07') delete from  GB_AuditProblem where TaskNo = N'2cd6265ff5164a1fb709cec29f7cbf07' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'2cd6265ff5164a1fb709cec29f7cbf07') delete from  GB_ProjectPlanCombine where TaskNo = N'2cd6265ff5164a1fb709cec29f7cbf07' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from  GB_ProjectPlanTeam where TaskNo = N'2cd6265ff5164a1fb709cec29f7cbf07') delete from  GB_ProjectPlanTeam where TaskNo = N'2cd6265ff5164a1fb709cec29f7cbf07' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'2cd6265ff5164a1fb709cec29f7cbf07') delete from  GB_ProjectPlanCombine where TaskNo = N'2cd6265ff5164a1fb709cec29f7cbf07' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'2cd6265ff5164a1fb709cec29f7cbf07') delete from  GB_ProjectPlanCombine where TaskNo = N'2cd6265ff5164a1fb709cec29f7cbf07' DELETE FROM base_bizColumnattach WHERE accesspath='GB_InvalidDoc' and keyvalue in (select id from  GB_InvalidDoc where TaskNo = N'2cd6265ff5164a1fb709cec29f7cbf07') delete from  GB_InvalidDoc where TaskNo = N'2cd6265ff5164a1fb709cec29f7cbf07' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from  GB_ProjectPlanTeam where TaskNo = N'2cd6265ff5164a1fb709cec29f7cbf07') delete from  GB_ProjectPlanTeam where TaskNo = N'2cd6265ff5164a1fb709cec29f7cbf07' DELETE FROM base_bizColumnattach WHERE accesspath='GB_AuditorContactRecord' and keyvalue in (select id from  GB_AuditorContactRecord where TaskNo = N'2cd6265ff5164a1fb709cec29f7cbf07') delete from  GB_AuditorContactRecord where TaskNo = N'2cd6265ff5164a1fb709cec29f7cbf07' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'2cd6265ff5164a1fb709cec29f7cbf07') delete from  GB_ProjectPlanCombine where TaskNo = N'2cd6265ff5164a1fb709cec29f7cbf07' DELETE FROM base_bizColumnattach WHERE accesspath='GB_AuditProblem' and keyvalue in (select id from  GB_AuditProblem where TaskNo = N'2cd6265ff5164a1fb709cec29f7cbf07') delete from  GB_AuditProblem where TaskNo = N'2cd6265ff5164a1fb709cec29f7cbf07' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from  GB_ProjectPlanTeam where TaskNo = N'2cd6265ff5164a1fb709cec29f7cbf07') delete from  GB_ProjectPlanTeam where TaskNo = N'2cd6265ff5164a1fb709cec29f7cbf07' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'2cd6265ff5164a1fb709cec29f7cbf07') delete from  GB_ProjectPlanCombine where TaskNo = N'2cd6265ff5164a1fb709cec29f7cbf07' DELETE FROM base_bizColumnattach WHERE accesspath='GB_AuditorContactRecord' and keyvalue in (select id from  GB_AuditorContactRecord where TaskNo = N'2cd6265ff5164a1fb709cec29f7cbf07') delete from  GB_AuditorContactRecord where TaskNo = N'2cd6265ff5164a1fb709cec29f7cbf07' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'2cd6265ff5164a1fb709cec29f7cbf07') delete from  GB_ProjectPlanCombine where TaskNo = N'2cd6265ff5164a1fb709cec29f7cbf07' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from  GB_ProjectPlanTeam where TaskNo = N'2cd6265ff5164a1fb709cec29f7cbf07') delete from  GB_ProjectPlanTeam where TaskNo = N'2cd6265ff5164a1fb709cec29f7cbf07' DELETE FROM GB_ProjectPlan WHERE ID='512000771' DELETE FROM base_bizattach WHERE bizentityid='003002' and keyvalue='512000771' DELETE FROM base_bizColumnattach WHERE bizentityid='003002' and keyvalue='512000771' DELETE FROM base_bizattach WHERE bizentityid='008001' and keyvalue='512000771' DELETE FROM base_bizColumnattach WHERE bizentityid='008001' and keyvalue='512000771' DELETE FROM base_bizattach WHERE bizentityid='003003' and keyvalue='512000771' DELETE FROM base_bizColumnattach WHERE bizentityid='003003' and keyvalue='512000771' DELETE FROM base_bizattach WHERE bizentityid='003004' and keyvalue='512000771' DELETE FROM base_bizColumnattach WHERE bizentityid='003004' and keyvalue='512000771' DELETE FROM base_bizattach WHERE bizentityid='003005' and keyvalue='512000771' DELETE FROM base_bizColumnattach WHERE bizentityid='003005' and keyvalue='512000771' DELETE FROM base_bizattach WHERE bizentityid='006001' and keyvalue='512000771' DELETE FROM base_bizColumnattach WHERE bizentityid='006001' and keyvalue='512000771' DELETE FROM base_bizattach WHERE bizentityid='006002' and keyvalue='512000771' DELETE FROM base_bizColumnattach WHERE bizentityid='006002' and keyvalue='512000771' DELETE FROM base_bizattach WHERE bizentityid='006003' and keyvalue='512000771' DELETE FROM base_bizColumnattach WHERE bizentityid='006003' and keyvalue='512000771' DELETE FROM base_bizattach WHERE bizentityid='004003' and keyvalue='512000771' DELETE FROM base_bizColumnattach WHERE bizentityid='004003' and keyvalue='512000771' DELETE FROM base_bizattach WHERE bizentityid='004004' and keyvalue='512000771' DELETE FROM base_bizColumnattach WHERE bizentityid='004004' and keyvalue='512000771' DELETE FROM base_bizattach WHERE bizentityid='008002' and keyvalue='512000771' DELETE FROM base_bizColumnattach WHERE bizentityid='008002' and keyvalue='512000771' DELETE FROM base_bizattach WHERE bizentityid='003006' and keyvalue='512000771' DELETE FROM base_bizColumnattach WHERE bizentityid='003006' and keyvalue='512000771' DELETE FROM base_bizattach WHERE bizentityid='001035001' and keyvalue='512000771' DELETE FROM base_bizColumnattach WHERE bizentityid='001035001' and keyvalue='512000771' DELETE FROM base_bizattach WHERE bizentityid='003025' and keyvalue='512000771' DELETE FROM base_bizColumnattach WHERE bizentityid='003025' and keyvalue='512000771' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='003002' and rowid='512000771') DELETE FROM wf_workflowinstance where bizentityid='003002' and rowid='512000771' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='008001' and rowid='512000771') DELETE FROM wf_workflowinstance where bizentityid='008001' and rowid='512000771' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='003003' and rowid='512000771') DELETE FROM wf_workflowinstance where bizentityid='003003' and rowid='512000771' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='003004' and rowid='512000771') DELETE FROM wf_workflowinstance where bizentityid='003004' and rowid='512000771' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='003005' and rowid='512000771') DELETE FROM wf_workflowinstance where bizentityid='003005' and rowid='512000771' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='006001' and rowid='512000771') DELETE FROM wf_workflowinstance where bizentityid='006001' and rowid='512000771' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='006002' and rowid='512000771') DELETE FROM wf_workflowinstance where bizentityid='006002' and rowid='512000771' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='006003' and rowid='512000771') DELETE FROM wf_workflowinstance where bizentityid='006003' and rowid='512000771' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='004003' and rowid='512000771') DELETE FROM wf_workflowinstance where bizentityid='004003' and rowid='512000771' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='004004' and rowid='512000771') DELETE FROM wf_workflowinstance where bizentityid='004004' and rowid='512000771' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='008002' and rowid='512000771') DELETE FROM wf_workflowinstance where bizentityid='008002' and rowid='512000771' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='003006' and rowid='512000771') DELETE FROM wf_workflowinstance where bizentityid='003006' and rowid='512000771' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='001035001' and rowid='512000771') DELETE FROM wf_workflowinstance where bizentityid='001035001' and rowid='512000771' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='003025' and rowid='512000771') DELETE FROM wf_workflowinstance where bizentityid='003025' and rowid='512000771' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='003002' and rowid='512000771') DELETE FROM wf_bizflowinstance where bizentityid='003002' and rowid='512000771' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='008001' and rowid='512000771') DELETE FROM wf_bizflowinstance where bizentityid='008001' and rowid='512000771' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='003003' and rowid='512000771') DELETE FROM wf_bizflowinstance where bizentityid='003003' and rowid='512000771' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='003004' and rowid='512000771') DELETE FROM wf_bizflowinstance where bizentityid='003004' and rowid='512000771' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='003005' and rowid='512000771') DELETE FROM wf_bizflowinstance where bizentityid='003005' and rowid='512000771' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='006001' and rowid='512000771') DELETE FROM wf_bizflowinstance where bizentityid='006001' and rowid='512000771' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='006002' and rowid='512000771') DELETE FROM wf_bizflowinstance where bizentityid='006002' and rowid='512000771' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='006003' and rowid='512000771') DELETE FROM wf_bizflowinstance where bizentityid='006003' and rowid='512000771' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='004003' and rowid='512000771') DELETE FROM wf_bizflowinstance where bizentityid='004003' and rowid='512000771' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='004004' and rowid='512000771') DELETE FROM wf_bizflowinstance where bizentityid='004004' and rowid='512000771' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='008002' and rowid='512000771') DELETE FROM wf_bizflowinstance where bizentityid='008002' and rowid='512000771' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='003006' and rowid='512000771') DELETE FROM wf_bizflowinstance where bizentityid='003006' and rowid='512000771' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='001035001' and rowid='512000771') DELETE FROM wf_bizflowinstance where bizentityid='001035001' and rowid='512000771' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='003025' and rowid='512000771') DELETE FROM wf_bizflowinstance where bizentityid='003025' and rowid='512000771'

2025-12-08 17:07:47 执行时长：8.66秒 sql:DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCerti' and keyvalue in (select id from  GB_ProjectPlanCerti where ProjectNo = N'20997-2025-QEO-O') delete from  GB_ProjectPlanCerti where ProjectNo = N'20997-2025-QEO-O' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCerti' and keyvalue in (select id from  GB_ProjectPlanCerti where ProjectNo = N'20997-2025-QEO-O') delete from  GB_ProjectPlanCerti where ProjectNo = N'20997-2025-QEO-O' DELETE FROM base_bizColumnattach WHERE accesspath='GB_CertiDoc' and keyvalue in (select id from  GB_CertiDoc where ProjectNo = N'20997-2025-QEO-O') delete from  GB_CertiDoc where ProjectNo = N'20997-2025-QEO-O' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanEnergy' and keyvalue in (select id from  GB_ProjectPlanEnergy where PlanNo = N'20997-2025-QEO-O-100') delete from  GB_ProjectPlanEnergy where PlanNo = N'20997-2025-QEO-O-100' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from  GB_ProjectPlanTeam where TaskNo = N'2cd6265ff5164a1fb709cec29f7cbf07') delete from  GB_ProjectPlanTeam where TaskNo = N'2cd6265ff5164a1fb709cec29f7cbf07' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'2cd6265ff5164a1fb709cec29f7cbf07') delete from  GB_ProjectPlanCombine where TaskNo = N'2cd6265ff5164a1fb709cec29f7cbf07' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'2cd6265ff5164a1fb709cec29f7cbf07') delete from  GB_ProjectPlanCombine where TaskNo = N'2cd6265ff5164a1fb709cec29f7cbf07' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'2cd6265ff5164a1fb709cec29f7cbf07') delete from  GB_ProjectPlanCombine where TaskNo = N'2cd6265ff5164a1fb709cec29f7cbf07' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'2cd6265ff5164a1fb709cec29f7cbf07') delete from  GB_ProjectPlanCombine where TaskNo = N'2cd6265ff5164a1fb709cec29f7cbf07' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'2cd6265ff5164a1fb709cec29f7cbf07') delete from  GB_ProjectPlanCombine where TaskNo = N'2cd6265ff5164a1fb709cec29f7cbf07' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from  GB_ProjectPlanTeam where TaskNo = N'2cd6265ff5164a1fb709cec29f7cbf07') delete from  GB_ProjectPlanTeam where TaskNo = N'2cd6265ff5164a1fb709cec29f7cbf07' DELETE FROM base_bizColumnattach WHERE accesspath='GB_AuditProblem' and keyvalue in (select id from  GB_AuditProblem where TaskNo = N'2cd6265ff5164a1fb709cec29f7cbf07') delete from  GB_AuditProblem where TaskNo = N'2cd6265ff5164a1fb709cec29f7cbf07' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'2cd6265ff5164a1fb709cec29f7cbf07') delete from  GB_ProjectPlanCombine where TaskNo = N'2cd6265ff5164a1fb709cec29f7cbf07' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from  GB_ProjectPlanTeam where TaskNo = N'2cd6265ff5164a1fb709cec29f7cbf07') delete from  GB_ProjectPlanTeam where TaskNo = N'2cd6265ff5164a1fb709cec29f7cbf07' DELETE FROM base_bizColumnattach WHERE accesspath='GB_AuditProblem' and keyvalue in (select id from  GB_AuditProblem where TaskNo = N'2cd6265ff5164a1fb709cec29f7cbf07') delete from  GB_AuditProblem where TaskNo = N'2cd6265ff5164a1fb709cec29f7cbf07' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'2cd6265ff5164a1fb709cec29f7cbf07') delete from  GB_ProjectPlanCombine where TaskNo = N'2cd6265ff5164a1fb709cec29f7cbf07' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from  GB_ProjectPlanTeam where TaskNo = N'2cd6265ff5164a1fb709cec29f7cbf07') delete from  GB_ProjectPlanTeam where TaskNo = N'2cd6265ff5164a1fb709cec29f7cbf07' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'2cd6265ff5164a1fb709cec29f7cbf07') delete from  GB_ProjectPlanCombine where TaskNo = N'2cd6265ff5164a1fb709cec29f7cbf07' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'2cd6265ff5164a1fb709cec29f7cbf07') delete from  GB_ProjectPlanCombine where TaskNo = N'2cd6265ff5164a1fb709cec29f7cbf07' DELETE FROM base_bizColumnattach WHERE accesspath='GB_InvalidDoc' and keyvalue in (select id from  GB_InvalidDoc where TaskNo = N'2cd6265ff5164a1fb709cec29f7cbf07') delete from  GB_InvalidDoc where TaskNo = N'2cd6265ff5164a1fb709cec29f7cbf07' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from  GB_ProjectPlanTeam where TaskNo = N'2cd6265ff5164a1fb709cec29f7cbf07') delete from  GB_ProjectPlanTeam where TaskNo = N'2cd6265ff5164a1fb709cec29f7cbf07' DELETE FROM base_bizColumnattach WHERE accesspath='GB_AuditorContactRecord' and keyvalue in (select id from  GB_AuditorContactRecord where TaskNo = N'2cd6265ff5164a1fb709cec29f7cbf07') delete from  GB_AuditorContactRecord where TaskNo = N'2cd6265ff5164a1fb709cec29f7cbf07' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'2cd6265ff5164a1fb709cec29f7cbf07') delete from  GB_ProjectPlanCombine where TaskNo = N'2cd6265ff5164a1fb709cec29f7cbf07' DELETE FROM base_bizColumnattach WHERE accesspath='GB_AuditProblem' and keyvalue in (select id from  GB_AuditProblem where TaskNo = N'2cd6265ff5164a1fb709cec29f7cbf07') delete from  GB_AuditProblem where TaskNo = N'2cd6265ff5164a1fb709cec29f7cbf07' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from  GB_ProjectPlanTeam where TaskNo = N'2cd6265ff5164a1fb709cec29f7cbf07') delete from  GB_ProjectPlanTeam where TaskNo = N'2cd6265ff5164a1fb709cec29f7cbf07' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'2cd6265ff5164a1fb709cec29f7cbf07') delete from  GB_ProjectPlanCombine where TaskNo = N'2cd6265ff5164a1fb709cec29f7cbf07' DELETE FROM base_bizColumnattach WHERE accesspath='GB_AuditorContactRecord' and keyvalue in (select id from  GB_AuditorContactRecord where TaskNo = N'2cd6265ff5164a1fb709cec29f7cbf07') delete from  GB_AuditorContactRecord where TaskNo = N'2cd6265ff5164a1fb709cec29f7cbf07' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'2cd6265ff5164a1fb709cec29f7cbf07') delete from  GB_ProjectPlanCombine where TaskNo = N'2cd6265ff5164a1fb709cec29f7cbf07' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from  GB_ProjectPlanTeam where TaskNo = N'2cd6265ff5164a1fb709cec29f7cbf07') delete from  GB_ProjectPlanTeam where TaskNo = N'2cd6265ff5164a1fb709cec29f7cbf07' DELETE FROM GB_ProjectPlan WHERE ID='512000773' DELETE FROM base_bizattach WHERE bizentityid='003002' and keyvalue='512000773' DELETE FROM base_bizColumnattach WHERE bizentityid='003002' and keyvalue='512000773' DELETE FROM base_bizattach WHERE bizentityid='008001' and keyvalue='512000773' DELETE FROM base_bizColumnattach WHERE bizentityid='008001' and keyvalue='512000773' DELETE FROM base_bizattach WHERE bizentityid='003003' and keyvalue='512000773' DELETE FROM base_bizColumnattach WHERE bizentityid='003003' and keyvalue='512000773' DELETE FROM base_bizattach WHERE bizentityid='003004' and keyvalue='512000773' DELETE FROM base_bizColumnattach WHERE bizentityid='003004' and keyvalue='512000773' DELETE FROM base_bizattach WHERE bizentityid='003005' and keyvalue='512000773' DELETE FROM base_bizColumnattach WHERE bizentityid='003005' and keyvalue='512000773' DELETE FROM base_bizattach WHERE bizentityid='006001' and keyvalue='512000773' DELETE FROM base_bizColumnattach WHERE bizentityid='006001' and keyvalue='512000773' DELETE FROM base_bizattach WHERE bizentityid='006002' and keyvalue='512000773' DELETE FROM base_bizColumnattach WHERE bizentityid='006002' and keyvalue='512000773' DELETE FROM base_bizattach WHERE bizentityid='006003' and keyvalue='512000773' DELETE FROM base_bizColumnattach WHERE bizentityid='006003' and keyvalue='512000773' DELETE FROM base_bizattach WHERE bizentityid='004003' and keyvalue='512000773' DELETE FROM base_bizColumnattach WHERE bizentityid='004003' and keyvalue='512000773' DELETE FROM base_bizattach WHERE bizentityid='004004' and keyvalue='512000773' DELETE FROM base_bizColumnattach WHERE bizentityid='004004' and keyvalue='512000773' DELETE FROM base_bizattach WHERE bizentityid='008002' and keyvalue='512000773' DELETE FROM base_bizColumnattach WHERE bizentityid='008002' and keyvalue='512000773' DELETE FROM base_bizattach WHERE bizentityid='003006' and keyvalue='512000773' DELETE FROM base_bizColumnattach WHERE bizentityid='003006' and keyvalue='512000773' DELETE FROM base_bizattach WHERE bizentityid='001035001' and keyvalue='512000773' DELETE FROM base_bizColumnattach WHERE bizentityid='001035001' and keyvalue='512000773' DELETE FROM base_bizattach WHERE bizentityid='003025' and keyvalue='512000773' DELETE FROM base_bizColumnattach WHERE bizentityid='003025' and keyvalue='512000773' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='003002' and rowid='512000773') DELETE FROM wf_workflowinstance where bizentityid='003002' and rowid='512000773' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='008001' and rowid='512000773') DELETE FROM wf_workflowinstance where bizentityid='008001' and rowid='512000773' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='003003' and rowid='512000773') DELETE FROM wf_workflowinstance where bizentityid='003003' and rowid='512000773' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='003004' and rowid='512000773') DELETE FROM wf_workflowinstance where bizentityid='003004' and rowid='512000773' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='003005' and rowid='512000773') DELETE FROM wf_workflowinstance where bizentityid='003005' and rowid='512000773' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='006001' and rowid='512000773') DELETE FROM wf_workflowinstance where bizentityid='006001' and rowid='512000773' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='006002' and rowid='512000773') DELETE FROM wf_workflowinstance where bizentityid='006002' and rowid='512000773' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='006003' and rowid='512000773') DELETE FROM wf_workflowinstance where bizentityid='006003' and rowid='512000773' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='004003' and rowid='512000773') DELETE FROM wf_workflowinstance where bizentityid='004003' and rowid='512000773' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='004004' and rowid='512000773') DELETE FROM wf_workflowinstance where bizentityid='004004' and rowid='512000773' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='008002' and rowid='512000773') DELETE FROM wf_workflowinstance where bizentityid='008002' and rowid='512000773' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='003006' and rowid='512000773') DELETE FROM wf_workflowinstance where bizentityid='003006' and rowid='512000773' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='001035001' and rowid='512000773') DELETE FROM wf_workflowinstance where bizentityid='001035001' and rowid='512000773' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='003025' and rowid='512000773') DELETE FROM wf_workflowinstance where bizentityid='003025' and rowid='512000773' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='003002' and rowid='512000773') DELETE FROM wf_bizflowinstance where bizentityid='003002' and rowid='512000773' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='008001' and rowid='512000773') DELETE FROM wf_bizflowinstance where bizentityid='008001' and rowid='512000773' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='003003' and rowid='512000773') DELETE FROM wf_bizflowinstance where bizentityid='003003' and rowid='512000773' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='003004' and rowid='512000773') DELETE FROM wf_bizflowinstance where bizentityid='003004' and rowid='512000773' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='003005' and rowid='512000773') DELETE FROM wf_bizflowinstance where bizentityid='003005' and rowid='512000773' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='006001' and rowid='512000773') DELETE FROM wf_bizflowinstance where bizentityid='006001' and rowid='512000773' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='006002' and rowid='512000773') DELETE FROM wf_bizflowinstance where bizentityid='006002' and rowid='512000773' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='006003' and rowid='512000773') DELETE FROM wf_bizflowinstance where bizentityid='006003' and rowid='512000773' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='004003' and rowid='512000773') DELETE FROM wf_bizflowinstance where bizentityid='004003' and rowid='512000773' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='004004' and rowid='512000773') DELETE FROM wf_bizflowinstance where bizentityid='004004' and rowid='512000773' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='008002' and rowid='512000773') DELETE FROM wf_bizflowinstance where bizentityid='008002' and rowid='512000773' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='003006' and rowid='512000773') DELETE FROM wf_bizflowinstance where bizentityid='003006' and rowid='512000773' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='001035001' and rowid='512000773') DELETE FROM wf_bizflowinstance where bizentityid='001035001' and rowid='512000773' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='003025' and rowid='512000773') DELETE FROM wf_bizflowinstance where bizentityid='003025' and rowid='512000773'

2025-12-08 17:07:56 执行时长：8.12秒 sql:DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCerti' and keyvalue in (select id from  GB_ProjectPlanCerti where ProjectNo = N'20997-2025-QEO-E') delete from  GB_ProjectPlanCerti where ProjectNo = N'20997-2025-QEO-E' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCerti' and keyvalue in (select id from  GB_ProjectPlanCerti where ProjectNo = N'20997-2025-QEO-E') delete from  GB_ProjectPlanCerti where ProjectNo = N'20997-2025-QEO-E' DELETE FROM base_bizColumnattach WHERE accesspath='GB_CertiDoc' and keyvalue in (select id from  GB_CertiDoc where ProjectNo = N'20997-2025-QEO-E') delete from  GB_CertiDoc where ProjectNo = N'20997-2025-QEO-E' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanEnergy' and keyvalue in (select id from  GB_ProjectPlanEnergy where PlanNo = N'20997-2025-QEO-E-200') delete from  GB_ProjectPlanEnergy where PlanNo = N'20997-2025-QEO-E-200' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from  GB_ProjectPlanTeam where TaskNo = N'20ccda099f714032afc7c1d6b9ef2d52') delete from  GB_ProjectPlanTeam where TaskNo = N'20ccda099f714032afc7c1d6b9ef2d52' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'20ccda099f714032afc7c1d6b9ef2d52') delete from  GB_ProjectPlanCombine where TaskNo = N'20ccda099f714032afc7c1d6b9ef2d52' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'20ccda099f714032afc7c1d6b9ef2d52') delete from  GB_ProjectPlanCombine where TaskNo = N'20ccda099f714032afc7c1d6b9ef2d52' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'20ccda099f714032afc7c1d6b9ef2d52') delete from  GB_ProjectPlanCombine where TaskNo = N'20ccda099f714032afc7c1d6b9ef2d52' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'20ccda099f714032afc7c1d6b9ef2d52') delete from  GB_ProjectPlanCombine where TaskNo = N'20ccda099f714032afc7c1d6b9ef2d52' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'20ccda099f714032afc7c1d6b9ef2d52') delete from  GB_ProjectPlanCombine where TaskNo = N'20ccda099f714032afc7c1d6b9ef2d52' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from  GB_ProjectPlanTeam where TaskNo = N'20ccda099f714032afc7c1d6b9ef2d52') delete from  GB_ProjectPlanTeam where TaskNo = N'20ccda099f714032afc7c1d6b9ef2d52' DELETE FROM base_bizColumnattach WHERE accesspath='GB_AuditProblem' and keyvalue in (select id from  GB_AuditProblem where TaskNo = N'20ccda099f714032afc7c1d6b9ef2d52') delete from  GB_AuditProblem where TaskNo = N'20ccda099f714032afc7c1d6b9ef2d52' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'20ccda099f714032afc7c1d6b9ef2d52') delete from  GB_ProjectPlanCombine where TaskNo = N'20ccda099f714032afc7c1d6b9ef2d52' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from  GB_ProjectPlanTeam where TaskNo = N'20ccda099f714032afc7c1d6b9ef2d52') delete from  GB_ProjectPlanTeam where TaskNo = N'20ccda099f714032afc7c1d6b9ef2d52' DELETE FROM base_bizColumnattach WHERE accesspath='GB_AuditProblem' and keyvalue in (select id from  GB_AuditProblem where TaskNo = N'20ccda099f714032afc7c1d6b9ef2d52') delete from  GB_AuditProblem where TaskNo = N'20ccda099f714032afc7c1d6b9ef2d52' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'20ccda099f714032afc7c1d6b9ef2d52') delete from  GB_ProjectPlanCombine where TaskNo = N'20ccda099f714032afc7c1d6b9ef2d52' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from  GB_ProjectPlanTeam where TaskNo = N'20ccda099f714032afc7c1d6b9ef2d52') delete from  GB_ProjectPlanTeam where TaskNo = N'20ccda099f714032afc7c1d6b9ef2d52' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'20ccda099f714032afc7c1d6b9ef2d52') delete from  GB_ProjectPlanCombine where TaskNo = N'20ccda099f714032afc7c1d6b9ef2d52' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'20ccda099f714032afc7c1d6b9ef2d52') delete from  GB_ProjectPlanCombine where TaskNo = N'20ccda099f714032afc7c1d6b9ef2d52' DELETE FROM base_bizColumnattach WHERE accesspath='GB_InvalidDoc' and keyvalue in (select id from  GB_InvalidDoc where TaskNo = N'20ccda099f714032afc7c1d6b9ef2d52') delete from  GB_InvalidDoc where TaskNo = N'20ccda099f714032afc7c1d6b9ef2d52' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from  GB_ProjectPlanTeam where TaskNo = N'20ccda099f714032afc7c1d6b9ef2d52') delete from  GB_ProjectPlanTeam where TaskNo = N'20ccda099f714032afc7c1d6b9ef2d52' DELETE FROM base_bizColumnattach WHERE accesspath='GB_AuditorContactRecord' and keyvalue in (select id from  GB_AuditorContactRecord where TaskNo = N'20ccda099f714032afc7c1d6b9ef2d52') delete from  GB_AuditorContactRecord where TaskNo = N'20ccda099f714032afc7c1d6b9ef2d52' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'20ccda099f714032afc7c1d6b9ef2d52') delete from  GB_ProjectPlanCombine where TaskNo = N'20ccda099f714032afc7c1d6b9ef2d52' DELETE FROM base_bizColumnattach WHERE accesspath='GB_AuditProblem' and keyvalue in (select id from  GB_AuditProblem where TaskNo = N'20ccda099f714032afc7c1d6b9ef2d52') delete from  GB_AuditProblem where TaskNo = N'20ccda099f714032afc7c1d6b9ef2d52' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from  GB_ProjectPlanTeam where TaskNo = N'20ccda099f714032afc7c1d6b9ef2d52') delete from  GB_ProjectPlanTeam where TaskNo = N'20ccda099f714032afc7c1d6b9ef2d52' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'20ccda099f714032afc7c1d6b9ef2d52') delete from  GB_ProjectPlanCombine where TaskNo = N'20ccda099f714032afc7c1d6b9ef2d52' DELETE FROM base_bizColumnattach WHERE accesspath='GB_AuditorContactRecord' and keyvalue in (select id from  GB_AuditorContactRecord where TaskNo = N'20ccda099f714032afc7c1d6b9ef2d52') delete from  GB_AuditorContactRecord where TaskNo = N'20ccda099f714032afc7c1d6b9ef2d52' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'20ccda099f714032afc7c1d6b9ef2d52') delete from  GB_ProjectPlanCombine where TaskNo = N'20ccda099f714032afc7c1d6b9ef2d52' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from  GB_ProjectPlanTeam where TaskNo = N'20ccda099f714032afc7c1d6b9ef2d52') delete from  GB_ProjectPlanTeam where TaskNo = N'20ccda099f714032afc7c1d6b9ef2d52' DELETE FROM GB_ProjectPlan WHERE ID='512000768' DELETE FROM base_bizattach WHERE bizentityid='003002' and keyvalue='512000768' DELETE FROM base_bizColumnattach WHERE bizentityid='003002' and keyvalue='512000768' DELETE FROM base_bizattach WHERE bizentityid='008001' and keyvalue='512000768' DELETE FROM base_bizColumnattach WHERE bizentityid='008001' and keyvalue='512000768' DELETE FROM base_bizattach WHERE bizentityid='003003' and keyvalue='512000768' DELETE FROM base_bizColumnattach WHERE bizentityid='003003' and keyvalue='512000768' DELETE FROM base_bizattach WHERE bizentityid='003004' and keyvalue='512000768' DELETE FROM base_bizColumnattach WHERE bizentityid='003004' and keyvalue='512000768' DELETE FROM base_bizattach WHERE bizentityid='003005' and keyvalue='512000768' DELETE FROM base_bizColumnattach WHERE bizentityid='003005' and keyvalue='512000768' DELETE FROM base_bizattach WHERE bizentityid='006001' and keyvalue='512000768' DELETE FROM base_bizColumnattach WHERE bizentityid='006001' and keyvalue='512000768' DELETE FROM base_bizattach WHERE bizentityid='006002' and keyvalue='512000768' DELETE FROM base_bizColumnattach WHERE bizentityid='006002' and keyvalue='512000768' DELETE FROM base_bizattach WHERE bizentityid='006003' and keyvalue='512000768' DELETE FROM base_bizColumnattach WHERE bizentityid='006003' and keyvalue='512000768' DELETE FROM base_bizattach WHERE bizentityid='004003' and keyvalue='512000768' DELETE FROM base_bizColumnattach WHERE bizentityid='004003' and keyvalue='512000768' DELETE FROM base_bizattach WHERE bizentityid='004004' and keyvalue='512000768' DELETE FROM base_bizColumnattach WHERE bizentityid='004004' and keyvalue='512000768' DELETE FROM base_bizattach WHERE bizentityid='008002' and keyvalue='512000768' DELETE FROM base_bizColumnattach WHERE bizentityid='008002' and keyvalue='512000768' DELETE FROM base_bizattach WHERE bizentityid='003006' and keyvalue='512000768' DELETE FROM base_bizColumnattach WHERE bizentityid='003006' and keyvalue='512000768' DELETE FROM base_bizattach WHERE bizentityid='001035001' and keyvalue='512000768' DELETE FROM base_bizColumnattach WHERE bizentityid='001035001' and keyvalue='512000768' DELETE FROM base_bizattach WHERE bizentityid='003025' and keyvalue='512000768' DELETE FROM base_bizColumnattach WHERE bizentityid='003025' and keyvalue='512000768' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='003002' and rowid='512000768') DELETE FROM wf_workflowinstance where bizentityid='003002' and rowid='512000768' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='008001' and rowid='512000768') DELETE FROM wf_workflowinstance where bizentityid='008001' and rowid='512000768' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='003003' and rowid='512000768') DELETE FROM wf_workflowinstance where bizentityid='003003' and rowid='512000768' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='003004' and rowid='512000768') DELETE FROM wf_workflowinstance where bizentityid='003004' and rowid='512000768' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='003005' and rowid='512000768') DELETE FROM wf_workflowinstance where bizentityid='003005' and rowid='512000768' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='006001' and rowid='512000768') DELETE FROM wf_workflowinstance where bizentityid='006001' and rowid='512000768' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='006002' and rowid='512000768') DELETE FROM wf_workflowinstance where bizentityid='006002' and rowid='512000768' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='006003' and rowid='512000768') DELETE FROM wf_workflowinstance where bizentityid='006003' and rowid='512000768' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='004003' and rowid='512000768') DELETE FROM wf_workflowinstance where bizentityid='004003' and rowid='512000768' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='004004' and rowid='512000768') DELETE FROM wf_workflowinstance where bizentityid='004004' and rowid='512000768' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='008002' and rowid='512000768') DELETE FROM wf_workflowinstance where bizentityid='008002' and rowid='512000768' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='003006' and rowid='512000768') DELETE FROM wf_workflowinstance where bizentityid='003006' and rowid='512000768' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='001035001' and rowid='512000768') DELETE FROM wf_workflowinstance where bizentityid='001035001' and rowid='512000768' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='003025' and rowid='512000768') DELETE FROM wf_workflowinstance where bizentityid='003025' and rowid='512000768' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='003002' and rowid='512000768') DELETE FROM wf_bizflowinstance where bizentityid='003002' and rowid='512000768' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='008001' and rowid='512000768') DELETE FROM wf_bizflowinstance where bizentityid='008001' and rowid='512000768' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='003003' and rowid='512000768') DELETE FROM wf_bizflowinstance where bizentityid='003003' and rowid='512000768' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='003004' and rowid='512000768') DELETE FROM wf_bizflowinstance where bizentityid='003004' and rowid='512000768' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='003005' and rowid='512000768') DELETE FROM wf_bizflowinstance where bizentityid='003005' and rowid='512000768' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='006001' and rowid='512000768') DELETE FROM wf_bizflowinstance where bizentityid='006001' and rowid='512000768' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='006002' and rowid='512000768') DELETE FROM wf_bizflowinstance where bizentityid='006002' and rowid='512000768' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='006003' and rowid='512000768') DELETE FROM wf_bizflowinstance where bizentityid='006003' and rowid='512000768' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='004003' and rowid='512000768') DELETE FROM wf_bizflowinstance where bizentityid='004003' and rowid='512000768' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='004004' and rowid='512000768') DELETE FROM wf_bizflowinstance where bizentityid='004004' and rowid='512000768' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='008002' and rowid='512000768') DELETE FROM wf_bizflowinstance where bizentityid='008002' and rowid='512000768' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='003006' and rowid='512000768') DELETE FROM wf_bizflowinstance where bizentityid='003006' and rowid='512000768' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='001035001' and rowid='512000768') DELETE FROM wf_bizflowinstance where bizentityid='001035001' and rowid='512000768' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='003025' and rowid='512000768') DELETE FROM wf_bizflowinstance where bizentityid='003025' and rowid='512000768'

2025-12-08 17:08:04 执行时长：7.83秒 sql:DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCerti' and keyvalue in (select id from  GB_ProjectPlanCerti where ProjectNo = N'20997-2025-QEO-O') delete from  GB_ProjectPlanCerti where ProjectNo = N'20997-2025-QEO-O' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCerti' and keyvalue in (select id from  GB_ProjectPlanCerti where ProjectNo = N'20997-2025-QEO-O') delete from  GB_ProjectPlanCerti where ProjectNo = N'20997-2025-QEO-O' DELETE FROM base_bizColumnattach WHERE accesspath='GB_CertiDoc' and keyvalue in (select id from  GB_CertiDoc where ProjectNo = N'20997-2025-QEO-O') delete from  GB_CertiDoc where ProjectNo = N'20997-2025-QEO-O' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanEnergy' and keyvalue in (select id from  GB_ProjectPlanEnergy where PlanNo = N'20997-2025-QEO-O-200') delete from  GB_ProjectPlanEnergy where PlanNo = N'20997-2025-QEO-O-200' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from  GB_ProjectPlanTeam where TaskNo = N'20ccda099f714032afc7c1d6b9ef2d52') delete from  GB_ProjectPlanTeam where TaskNo = N'20ccda099f714032afc7c1d6b9ef2d52' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'20ccda099f714032afc7c1d6b9ef2d52') delete from  GB_ProjectPlanCombine where TaskNo = N'20ccda099f714032afc7c1d6b9ef2d52' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'20ccda099f714032afc7c1d6b9ef2d52') delete from  GB_ProjectPlanCombine where TaskNo = N'20ccda099f714032afc7c1d6b9ef2d52' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'20ccda099f714032afc7c1d6b9ef2d52') delete from  GB_ProjectPlanCombine where TaskNo = N'20ccda099f714032afc7c1d6b9ef2d52' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'20ccda099f714032afc7c1d6b9ef2d52') delete from  GB_ProjectPlanCombine where TaskNo = N'20ccda099f714032afc7c1d6b9ef2d52' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'20ccda099f714032afc7c1d6b9ef2d52') delete from  GB_ProjectPlanCombine where TaskNo = N'20ccda099f714032afc7c1d6b9ef2d52' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from  GB_ProjectPlanTeam where TaskNo = N'20ccda099f714032afc7c1d6b9ef2d52') delete from  GB_ProjectPlanTeam where TaskNo = N'20ccda099f714032afc7c1d6b9ef2d52' DELETE FROM base_bizColumnattach WHERE accesspath='GB_AuditProblem' and keyvalue in (select id from  GB_AuditProblem where TaskNo = N'20ccda099f714032afc7c1d6b9ef2d52') delete from  GB_AuditProblem where TaskNo = N'20ccda099f714032afc7c1d6b9ef2d52' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'20ccda099f714032afc7c1d6b9ef2d52') delete from  GB_ProjectPlanCombine where TaskNo = N'20ccda099f714032afc7c1d6b9ef2d52' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from  GB_ProjectPlanTeam where TaskNo = N'20ccda099f714032afc7c1d6b9ef2d52') delete from  GB_ProjectPlanTeam where TaskNo = N'20ccda099f714032afc7c1d6b9ef2d52' DELETE FROM base_bizColumnattach WHERE accesspath='GB_AuditProblem' and keyvalue in (select id from  GB_AuditProblem where TaskNo = N'20ccda099f714032afc7c1d6b9ef2d52') delete from  GB_AuditProblem where TaskNo = N'20ccda099f714032afc7c1d6b9ef2d52' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'20ccda099f714032afc7c1d6b9ef2d52') delete from  GB_ProjectPlanCombine where TaskNo = N'20ccda099f714032afc7c1d6b9ef2d52' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from  GB_ProjectPlanTeam where TaskNo = N'20ccda099f714032afc7c1d6b9ef2d52') delete from  GB_ProjectPlanTeam where TaskNo = N'20ccda099f714032afc7c1d6b9ef2d52' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'20ccda099f714032afc7c1d6b9ef2d52') delete from  GB_ProjectPlanCombine where TaskNo = N'20ccda099f714032afc7c1d6b9ef2d52' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'20ccda099f714032afc7c1d6b9ef2d52') delete from  GB_ProjectPlanCombine where TaskNo = N'20ccda099f714032afc7c1d6b9ef2d52' DELETE FROM base_bizColumnattach WHERE accesspath='GB_InvalidDoc' and keyvalue in (select id from  GB_InvalidDoc where TaskNo = N'20ccda099f714032afc7c1d6b9ef2d52') delete from  GB_InvalidDoc where TaskNo = N'20ccda099f714032afc7c1d6b9ef2d52' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from  GB_ProjectPlanTeam where TaskNo = N'20ccda099f714032afc7c1d6b9ef2d52') delete from  GB_ProjectPlanTeam where TaskNo = N'20ccda099f714032afc7c1d6b9ef2d52' DELETE FROM base_bizColumnattach WHERE accesspath='GB_AuditorContactRecord' and keyvalue in (select id from  GB_AuditorContactRecord where TaskNo = N'20ccda099f714032afc7c1d6b9ef2d52') delete from  GB_AuditorContactRecord where TaskNo = N'20ccda099f714032afc7c1d6b9ef2d52' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'20ccda099f714032afc7c1d6b9ef2d52') delete from  GB_ProjectPlanCombine where TaskNo = N'20ccda099f714032afc7c1d6b9ef2d52' DELETE FROM base_bizColumnattach WHERE accesspath='GB_AuditProblem' and keyvalue in (select id from  GB_AuditProblem where TaskNo = N'20ccda099f714032afc7c1d6b9ef2d52') delete from  GB_AuditProblem where TaskNo = N'20ccda099f714032afc7c1d6b9ef2d52' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from  GB_ProjectPlanTeam where TaskNo = N'20ccda099f714032afc7c1d6b9ef2d52') delete from  GB_ProjectPlanTeam where TaskNo = N'20ccda099f714032afc7c1d6b9ef2d52' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'20ccda099f714032afc7c1d6b9ef2d52') delete from  GB_ProjectPlanCombine where TaskNo = N'20ccda099f714032afc7c1d6b9ef2d52' DELETE FROM base_bizColumnattach WHERE accesspath='GB_AuditorContactRecord' and keyvalue in (select id from  GB_AuditorContactRecord where TaskNo = N'20ccda099f714032afc7c1d6b9ef2d52') delete from  GB_AuditorContactRecord where TaskNo = N'20ccda099f714032afc7c1d6b9ef2d52' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'20ccda099f714032afc7c1d6b9ef2d52') delete from  GB_ProjectPlanCombine where TaskNo = N'20ccda099f714032afc7c1d6b9ef2d52' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from  GB_ProjectPlanTeam where TaskNo = N'20ccda099f714032afc7c1d6b9ef2d52') delete from  GB_ProjectPlanTeam where TaskNo = N'20ccda099f714032afc7c1d6b9ef2d52' DELETE FROM GB_ProjectPlan WHERE ID='512000772' DELETE FROM base_bizattach WHERE bizentityid='003002' and keyvalue='512000772' DELETE FROM base_bizColumnattach WHERE bizentityid='003002' and keyvalue='512000772' DELETE FROM base_bizattach WHERE bizentityid='008001' and keyvalue='512000772' DELETE FROM base_bizColumnattach WHERE bizentityid='008001' and keyvalue='512000772' DELETE FROM base_bizattach WHERE bizentityid='003003' and keyvalue='512000772' DELETE FROM base_bizColumnattach WHERE bizentityid='003003' and keyvalue='512000772' DELETE FROM base_bizattach WHERE bizentityid='003004' and keyvalue='512000772' DELETE FROM base_bizColumnattach WHERE bizentityid='003004' and keyvalue='512000772' DELETE FROM base_bizattach WHERE bizentityid='003005' and keyvalue='512000772' DELETE FROM base_bizColumnattach WHERE bizentityid='003005' and keyvalue='512000772' DELETE FROM base_bizattach WHERE bizentityid='006001' and keyvalue='512000772' DELETE FROM base_bizColumnattach WHERE bizentityid='006001' and keyvalue='512000772' DELETE FROM base_bizattach WHERE bizentityid='006002' and keyvalue='512000772' DELETE FROM base_bizColumnattach WHERE bizentityid='006002' and keyvalue='512000772' DELETE FROM base_bizattach WHERE bizentityid='006003' and keyvalue='512000772' DELETE FROM base_bizColumnattach WHERE bizentityid='006003' and keyvalue='512000772' DELETE FROM base_bizattach WHERE bizentityid='004003' and keyvalue='512000772' DELETE FROM base_bizColumnattach WHERE bizentityid='004003' and keyvalue='512000772' DELETE FROM base_bizattach WHERE bizentityid='004004' and keyvalue='512000772' DELETE FROM base_bizColumnattach WHERE bizentityid='004004' and keyvalue='512000772' DELETE FROM base_bizattach WHERE bizentityid='008002' and keyvalue='512000772' DELETE FROM base_bizColumnattach WHERE bizentityid='008002' and keyvalue='512000772' DELETE FROM base_bizattach WHERE bizentityid='003006' and keyvalue='512000772' DELETE FROM base_bizColumnattach WHERE bizentityid='003006' and keyvalue='512000772' DELETE FROM base_bizattach WHERE bizentityid='001035001' and keyvalue='512000772' DELETE FROM base_bizColumnattach WHERE bizentityid='001035001' and keyvalue='512000772' DELETE FROM base_bizattach WHERE bizentityid='003025' and keyvalue='512000772' DELETE FROM base_bizColumnattach WHERE bizentityid='003025' and keyvalue='512000772' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='003002' and rowid='512000772') DELETE FROM wf_workflowinstance where bizentityid='003002' and rowid='512000772' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='008001' and rowid='512000772') DELETE FROM wf_workflowinstance where bizentityid='008001' and rowid='512000772' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='003003' and rowid='512000772') DELETE FROM wf_workflowinstance where bizentityid='003003' and rowid='512000772' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='003004' and rowid='512000772') DELETE FROM wf_workflowinstance where bizentityid='003004' and rowid='512000772' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='003005' and rowid='512000772') DELETE FROM wf_workflowinstance where bizentityid='003005' and rowid='512000772' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='006001' and rowid='512000772') DELETE FROM wf_workflowinstance where bizentityid='006001' and rowid='512000772' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='006002' and rowid='512000772') DELETE FROM wf_workflowinstance where bizentityid='006002' and rowid='512000772' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='006003' and rowid='512000772') DELETE FROM wf_workflowinstance where bizentityid='006003' and rowid='512000772' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='004003' and rowid='512000772') DELETE FROM wf_workflowinstance where bizentityid='004003' and rowid='512000772' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='004004' and rowid='512000772') DELETE FROM wf_workflowinstance where bizentityid='004004' and rowid='512000772' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='008002' and rowid='512000772') DELETE FROM wf_workflowinstance where bizentityid='008002' and rowid='512000772' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='003006' and rowid='512000772') DELETE FROM wf_workflowinstance where bizentityid='003006' and rowid='512000772' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='001035001' and rowid='512000772') DELETE FROM wf_workflowinstance where bizentityid='001035001' and rowid='512000772' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='003025' and rowid='512000772') DELETE FROM wf_workflowinstance where bizentityid='003025' and rowid='512000772' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='003002' and rowid='512000772') DELETE FROM wf_bizflowinstance where bizentityid='003002' and rowid='512000772' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='008001' and rowid='512000772') DELETE FROM wf_bizflowinstance where bizentityid='008001' and rowid='512000772' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='003003' and rowid='512000772') DELETE FROM wf_bizflowinstance where bizentityid='003003' and rowid='512000772' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='003004' and rowid='512000772') DELETE FROM wf_bizflowinstance where bizentityid='003004' and rowid='512000772' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='003005' and rowid='512000772') DELETE FROM wf_bizflowinstance where bizentityid='003005' and rowid='512000772' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='006001' and rowid='512000772') DELETE FROM wf_bizflowinstance where bizentityid='006001' and rowid='512000772' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='006002' and rowid='512000772') DELETE FROM wf_bizflowinstance where bizentityid='006002' and rowid='512000772' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='006003' and rowid='512000772') DELETE FROM wf_bizflowinstance where bizentityid='006003' and rowid='512000772' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='004003' and rowid='512000772') DELETE FROM wf_bizflowinstance where bizentityid='004003' and rowid='512000772' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='004004' and rowid='512000772') DELETE FROM wf_bizflowinstance where bizentityid='004004' and rowid='512000772' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='008002' and rowid='512000772') DELETE FROM wf_bizflowinstance where bizentityid='008002' and rowid='512000772' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='003006' and rowid='512000772') DELETE FROM wf_bizflowinstance where bizentityid='003006' and rowid='512000772' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='001035001' and rowid='512000772') DELETE FROM wf_bizflowinstance where bizentityid='001035001' and rowid='512000772' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='003025' and rowid='512000772') DELETE FROM wf_bizflowinstance where bizentityid='003025' and rowid='512000772'

2025-12-08 17:08:14 执行时长：9.64秒 sql:DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCerti' and keyvalue in (select id from  GB_ProjectPlanCerti where ProjectNo = N'20997-2025-QEO-Q') delete from  GB_ProjectPlanCerti where ProjectNo = N'20997-2025-QEO-Q' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCerti' and keyvalue in (select id from  GB_ProjectPlanCerti where ProjectNo = N'20997-2025-QEO-Q') delete from  GB_ProjectPlanCerti where ProjectNo = N'20997-2025-QEO-Q' DELETE FROM base_bizColumnattach WHERE accesspath='GB_CertiDoc' and keyvalue in (select id from  GB_CertiDoc where ProjectNo = N'20997-2025-QEO-Q') delete from  GB_CertiDoc where ProjectNo = N'20997-2025-QEO-Q' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanEnergy' and keyvalue in (select id from  GB_ProjectPlanEnergy where PlanNo = N'20997-2025-QEO-Q-200') delete from  GB_ProjectPlanEnergy where PlanNo = N'20997-2025-QEO-Q-200' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from  GB_ProjectPlanTeam where TaskNo = N'20ccda099f714032afc7c1d6b9ef2d52') delete from  GB_ProjectPlanTeam where TaskNo = N'20ccda099f714032afc7c1d6b9ef2d52' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'20ccda099f714032afc7c1d6b9ef2d52') delete from  GB_ProjectPlanCombine where TaskNo = N'20ccda099f714032afc7c1d6b9ef2d52' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'20ccda099f714032afc7c1d6b9ef2d52') delete from  GB_ProjectPlanCombine where TaskNo = N'20ccda099f714032afc7c1d6b9ef2d52' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'20ccda099f714032afc7c1d6b9ef2d52') delete from  GB_ProjectPlanCombine where TaskNo = N'20ccda099f714032afc7c1d6b9ef2d52' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'20ccda099f714032afc7c1d6b9ef2d52') delete from  GB_ProjectPlanCombine where TaskNo = N'20ccda099f714032afc7c1d6b9ef2d52' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'20ccda099f714032afc7c1d6b9ef2d52') delete from  GB_ProjectPlanCombine where TaskNo = N'20ccda099f714032afc7c1d6b9ef2d52' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from  GB_ProjectPlanTeam where TaskNo = N'20ccda099f714032afc7c1d6b9ef2d52') delete from  GB_ProjectPlanTeam where TaskNo = N'20ccda099f714032afc7c1d6b9ef2d52' DELETE FROM base_bizColumnattach WHERE accesspath='GB_AuditProblem' and keyvalue in (select id from  GB_AuditProblem where TaskNo = N'20ccda099f714032afc7c1d6b9ef2d52') delete from  GB_AuditProblem where TaskNo = N'20ccda099f714032afc7c1d6b9ef2d52' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'20ccda099f714032afc7c1d6b9ef2d52') delete from  GB_ProjectPlanCombine where TaskNo = N'20ccda099f714032afc7c1d6b9ef2d52' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from  GB_ProjectPlanTeam where TaskNo = N'20ccda099f714032afc7c1d6b9ef2d52') delete from  GB_ProjectPlanTeam where TaskNo = N'20ccda099f714032afc7c1d6b9ef2d52' DELETE FROM base_bizColumnattach WHERE accesspath='GB_AuditProblem' and keyvalue in (select id from  GB_AuditProblem where TaskNo = N'20ccda099f714032afc7c1d6b9ef2d52') delete from  GB_AuditProblem where TaskNo = N'20ccda099f714032afc7c1d6b9ef2d52' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'20ccda099f714032afc7c1d6b9ef2d52') delete from  GB_ProjectPlanCombine where TaskNo = N'20ccda099f714032afc7c1d6b9ef2d52' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from  GB_ProjectPlanTeam where TaskNo = N'20ccda099f714032afc7c1d6b9ef2d52') delete from  GB_ProjectPlanTeam where TaskNo = N'20ccda099f714032afc7c1d6b9ef2d52' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'20ccda099f714032afc7c1d6b9ef2d52') delete from  GB_ProjectPlanCombine where TaskNo = N'20ccda099f714032afc7c1d6b9ef2d52' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'20ccda099f714032afc7c1d6b9ef2d52') delete from  GB_ProjectPlanCombine where TaskNo = N'20ccda099f714032afc7c1d6b9ef2d52' DELETE FROM base_bizColumnattach WHERE accesspath='GB_InvalidDoc' and keyvalue in (select id from  GB_InvalidDoc where TaskNo = N'20ccda099f714032afc7c1d6b9ef2d52') delete from  GB_InvalidDoc where TaskNo = N'20ccda099f714032afc7c1d6b9ef2d52' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from  GB_ProjectPlanTeam where TaskNo = N'20ccda099f714032afc7c1d6b9ef2d52') delete from  GB_ProjectPlanTeam where TaskNo = N'20ccda099f714032afc7c1d6b9ef2d52' DELETE FROM base_bizColumnattach WHERE accesspath='GB_AuditorContactRecord' and keyvalue in (select id from  GB_AuditorContactRecord where TaskNo = N'20ccda099f714032afc7c1d6b9ef2d52') delete from  GB_AuditorContactRecord where TaskNo = N'20ccda099f714032afc7c1d6b9ef2d52' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'20ccda099f714032afc7c1d6b9ef2d52') delete from  GB_ProjectPlanCombine where TaskNo = N'20ccda099f714032afc7c1d6b9ef2d52' DELETE FROM base_bizColumnattach WHERE accesspath='GB_AuditProblem' and keyvalue in (select id from  GB_AuditProblem where TaskNo = N'20ccda099f714032afc7c1d6b9ef2d52') delete from  GB_AuditProblem where TaskNo = N'20ccda099f714032afc7c1d6b9ef2d52' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from  GB_ProjectPlanTeam where TaskNo = N'20ccda099f714032afc7c1d6b9ef2d52') delete from  GB_ProjectPlanTeam where TaskNo = N'20ccda099f714032afc7c1d6b9ef2d52' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'20ccda099f714032afc7c1d6b9ef2d52') delete from  GB_ProjectPlanCombine where TaskNo = N'20ccda099f714032afc7c1d6b9ef2d52' DELETE FROM base_bizColumnattach WHERE accesspath='GB_AuditorContactRecord' and keyvalue in (select id from  GB_AuditorContactRecord where TaskNo = N'20ccda099f714032afc7c1d6b9ef2d52') delete from  GB_AuditorContactRecord where TaskNo = N'20ccda099f714032afc7c1d6b9ef2d52' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'20ccda099f714032afc7c1d6b9ef2d52') delete from  GB_ProjectPlanCombine where TaskNo = N'20ccda099f714032afc7c1d6b9ef2d52' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from  GB_ProjectPlanTeam where TaskNo = N'20ccda099f714032afc7c1d6b9ef2d52') delete from  GB_ProjectPlanTeam where TaskNo = N'20ccda099f714032afc7c1d6b9ef2d52' DELETE FROM GB_ProjectPlan WHERE ID='512000770' DELETE FROM base_bizattach WHERE bizentityid='003002' and keyvalue='512000770' DELETE FROM base_bizColumnattach WHERE bizentityid='003002' and keyvalue='512000770' DELETE FROM base_bizattach WHERE bizentityid='008001' and keyvalue='512000770' DELETE FROM base_bizColumnattach WHERE bizentityid='008001' and keyvalue='512000770' DELETE FROM base_bizattach WHERE bizentityid='003003' and keyvalue='512000770' DELETE FROM base_bizColumnattach WHERE bizentityid='003003' and keyvalue='512000770' DELETE FROM base_bizattach WHERE bizentityid='003004' and keyvalue='512000770' DELETE FROM base_bizColumnattach WHERE bizentityid='003004' and keyvalue='512000770' DELETE FROM base_bizattach WHERE bizentityid='003005' and keyvalue='512000770' DELETE FROM base_bizColumnattach WHERE bizentityid='003005' and keyvalue='512000770' DELETE FROM base_bizattach WHERE bizentityid='006001' and keyvalue='512000770' DELETE FROM base_bizColumnattach WHERE bizentityid='006001' and keyvalue='512000770' DELETE FROM base_bizattach WHERE bizentityid='006002' and keyvalue='512000770' DELETE FROM base_bizColumnattach WHERE bizentityid='006002' and keyvalue='512000770' DELETE FROM base_bizattach WHERE bizentityid='006003' and keyvalue='512000770' DELETE FROM base_bizColumnattach WHERE bizentityid='006003' and keyvalue='512000770' DELETE FROM base_bizattach WHERE bizentityid='004003' and keyvalue='512000770' DELETE FROM base_bizColumnattach WHERE bizentityid='004003' and keyvalue='512000770' DELETE FROM base_bizattach WHERE bizentityid='004004' and keyvalue='512000770' DELETE FROM base_bizColumnattach WHERE bizentityid='004004' and keyvalue='512000770' DELETE FROM base_bizattach WHERE bizentityid='008002' and keyvalue='512000770' DELETE FROM base_bizColumnattach WHERE bizentityid='008002' and keyvalue='512000770' DELETE FROM base_bizattach WHERE bizentityid='003006' and keyvalue='512000770' DELETE FROM base_bizColumnattach WHERE bizentityid='003006' and keyvalue='512000770' DELETE FROM base_bizattach WHERE bizentityid='001035001' and keyvalue='512000770' DELETE FROM base_bizColumnattach WHERE bizentityid='001035001' and keyvalue='512000770' DELETE FROM base_bizattach WHERE bizentityid='003025' and keyvalue='512000770' DELETE FROM base_bizColumnattach WHERE bizentityid='003025' and keyvalue='512000770' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='003002' and rowid='512000770') DELETE FROM wf_workflowinstance where bizentityid='003002' and rowid='512000770' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='008001' and rowid='512000770') DELETE FROM wf_workflowinstance where bizentityid='008001' and rowid='512000770' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='003003' and rowid='512000770') DELETE FROM wf_workflowinstance where bizentityid='003003' and rowid='512000770' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='003004' and rowid='512000770') DELETE FROM wf_workflowinstance where bizentityid='003004' and rowid='512000770' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='003005' and rowid='512000770') DELETE FROM wf_workflowinstance where bizentityid='003005' and rowid='512000770' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='006001' and rowid='512000770') DELETE FROM wf_workflowinstance where bizentityid='006001' and rowid='512000770' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='006002' and rowid='512000770') DELETE FROM wf_workflowinstance where bizentityid='006002' and rowid='512000770' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='006003' and rowid='512000770') DELETE FROM wf_workflowinstance where bizentityid='006003' and rowid='512000770' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='004003' and rowid='512000770') DELETE FROM wf_workflowinstance where bizentityid='004003' and rowid='512000770' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='004004' and rowid='512000770') DELETE FROM wf_workflowinstance where bizentityid='004004' and rowid='512000770' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='008002' and rowid='512000770') DELETE FROM wf_workflowinstance where bizentityid='008002' and rowid='512000770' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='003006' and rowid='512000770') DELETE FROM wf_workflowinstance where bizentityid='003006' and rowid='512000770' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='001035001' and rowid='512000770') DELETE FROM wf_workflowinstance where bizentityid='001035001' and rowid='512000770' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='003025' and rowid='512000770') DELETE FROM wf_workflowinstance where bizentityid='003025' and rowid='512000770' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='003002' and rowid='512000770') DELETE FROM wf_bizflowinstance where bizentityid='003002' and rowid='512000770' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='008001' and rowid='512000770') DELETE FROM wf_bizflowinstance where bizentityid='008001' and rowid='512000770' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='003003' and rowid='512000770') DELETE FROM wf_bizflowinstance where bizentityid='003003' and rowid='512000770' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='003004' and rowid='512000770') DELETE FROM wf_bizflowinstance where bizentityid='003004' and rowid='512000770' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='003005' and rowid='512000770') DELETE FROM wf_bizflowinstance where bizentityid='003005' and rowid='512000770' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='006001' and rowid='512000770') DELETE FROM wf_bizflowinstance where bizentityid='006001' and rowid='512000770' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='006002' and rowid='512000770') DELETE FROM wf_bizflowinstance where bizentityid='006002' and rowid='512000770' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='006003' and rowid='512000770') DELETE FROM wf_bizflowinstance where bizentityid='006003' and rowid='512000770' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='004003' and rowid='512000770') DELETE FROM wf_bizflowinstance where bizentityid='004003' and rowid='512000770' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='004004' and rowid='512000770') DELETE FROM wf_bizflowinstance where bizentityid='004004' and rowid='512000770' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='008002' and rowid='512000770') DELETE FROM wf_bizflowinstance where bizentityid='008002' and rowid='512000770' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='003006' and rowid='512000770') DELETE FROM wf_bizflowinstance where bizentityid='003006' and rowid='512000770' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='001035001' and rowid='512000770') DELETE FROM wf_bizflowinstance where bizentityid='001035001' and rowid='512000770' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='003025' and rowid='512000770') DELETE FROM wf_bizflowinstance where bizentityid='003025' and rowid='512000770'

2025-12-08 17:12:10 执行时长：8.19秒 sql:DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCerti' and keyvalue in (select id from  GB_ProjectPlanCerti where ProjectNo = N'20983-2024-QEO-O') delete from  GB_ProjectPlanCerti where ProjectNo = N'20983-2024-QEO-O' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCerti' and keyvalue in (select id from  GB_ProjectPlanCerti where ProjectNo = N'20983-2024-QEO-O') delete from  GB_ProjectPlanCerti where ProjectNo = N'20983-2024-QEO-O' DELETE FROM base_bizColumnattach WHERE accesspath='GB_CertiDoc' and keyvalue in (select id from  GB_CertiDoc where ProjectNo = N'20983-2024-QEO-O') delete from  GB_CertiDoc where ProjectNo = N'20983-2024-QEO-O' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanEnergy' and keyvalue in (select id from  GB_ProjectPlanEnergy where PlanNo = N'20983-2024-QEO-O-100') delete from  GB_ProjectPlanEnergy where PlanNo = N'20983-2024-QEO-O-100' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from  GB_ProjectPlanTeam where TaskNo = N'715c535ad9a7447685ddc2a01c873fa4') delete from  GB_ProjectPlanTeam where TaskNo = N'715c535ad9a7447685ddc2a01c873fa4' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'715c535ad9a7447685ddc2a01c873fa4') delete from  GB_ProjectPlanCombine where TaskNo = N'715c535ad9a7447685ddc2a01c873fa4' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'715c535ad9a7447685ddc2a01c873fa4') delete from  GB_ProjectPlanCombine where TaskNo = N'715c535ad9a7447685ddc2a01c873fa4' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'715c535ad9a7447685ddc2a01c873fa4') delete from  GB_ProjectPlanCombine where TaskNo = N'715c535ad9a7447685ddc2a01c873fa4' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'715c535ad9a7447685ddc2a01c873fa4') delete from  GB_ProjectPlanCombine where TaskNo = N'715c535ad9a7447685ddc2a01c873fa4' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'715c535ad9a7447685ddc2a01c873fa4') delete from  GB_ProjectPlanCombine where TaskNo = N'715c535ad9a7447685ddc2a01c873fa4' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from  GB_ProjectPlanTeam where TaskNo = N'715c535ad9a7447685ddc2a01c873fa4') delete from  GB_ProjectPlanTeam where TaskNo = N'715c535ad9a7447685ddc2a01c873fa4' DELETE FROM base_bizColumnattach WHERE accesspath='GB_AuditProblem' and keyvalue in (select id from  GB_AuditProblem where TaskNo = N'715c535ad9a7447685ddc2a01c873fa4') delete from  GB_AuditProblem where TaskNo = N'715c535ad9a7447685ddc2a01c873fa4' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'715c535ad9a7447685ddc2a01c873fa4') delete from  GB_ProjectPlanCombine where TaskNo = N'715c535ad9a7447685ddc2a01c873fa4' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from  GB_ProjectPlanTeam where TaskNo = N'715c535ad9a7447685ddc2a01c873fa4') delete from  GB_ProjectPlanTeam where TaskNo = N'715c535ad9a7447685ddc2a01c873fa4' DELETE FROM base_bizColumnattach WHERE accesspath='GB_AuditProblem' and keyvalue in (select id from  GB_AuditProblem where TaskNo = N'715c535ad9a7447685ddc2a01c873fa4') delete from  GB_AuditProblem where TaskNo = N'715c535ad9a7447685ddc2a01c873fa4' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'715c535ad9a7447685ddc2a01c873fa4') delete from  GB_ProjectPlanCombine where TaskNo = N'715c535ad9a7447685ddc2a01c873fa4' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from  GB_ProjectPlanTeam where TaskNo = N'715c535ad9a7447685ddc2a01c873fa4') delete from  GB_ProjectPlanTeam where TaskNo = N'715c535ad9a7447685ddc2a01c873fa4' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'715c535ad9a7447685ddc2a01c873fa4') delete from  GB_ProjectPlanCombine where TaskNo = N'715c535ad9a7447685ddc2a01c873fa4' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'715c535ad9a7447685ddc2a01c873fa4') delete from  GB_ProjectPlanCombine where TaskNo = N'715c535ad9a7447685ddc2a01c873fa4' DELETE FROM base_bizColumnattach WHERE accesspath='GB_InvalidDoc' and keyvalue in (select id from  GB_InvalidDoc where TaskNo = N'715c535ad9a7447685ddc2a01c873fa4') delete from  GB_InvalidDoc where TaskNo = N'715c535ad9a7447685ddc2a01c873fa4' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from  GB_ProjectPlanTeam where TaskNo = N'715c535ad9a7447685ddc2a01c873fa4') delete from  GB_ProjectPlanTeam where TaskNo = N'715c535ad9a7447685ddc2a01c873fa4' DELETE FROM base_bizColumnattach WHERE accesspath='GB_AuditorContactRecord' and keyvalue in (select id from  GB_AuditorContactRecord where TaskNo = N'715c535ad9a7447685ddc2a01c873fa4') delete from  GB_AuditorContactRecord where TaskNo = N'715c535ad9a7447685ddc2a01c873fa4' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'715c535ad9a7447685ddc2a01c873fa4') delete from  GB_ProjectPlanCombine where TaskNo = N'715c535ad9a7447685ddc2a01c873fa4' DELETE FROM base_bizColumnattach WHERE accesspath='GB_AuditProblem' and keyvalue in (select id from  GB_AuditProblem where TaskNo = N'715c535ad9a7447685ddc2a01c873fa4') delete from  GB_AuditProblem where TaskNo = N'715c535ad9a7447685ddc2a01c873fa4' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from  GB_ProjectPlanTeam where TaskNo = N'715c535ad9a7447685ddc2a01c873fa4') delete from  GB_ProjectPlanTeam where TaskNo = N'715c535ad9a7447685ddc2a01c873fa4' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'715c535ad9a7447685ddc2a01c873fa4') delete from  GB_ProjectPlanCombine where TaskNo = N'715c535ad9a7447685ddc2a01c873fa4' DELETE FROM base_bizColumnattach WHERE accesspath='GB_AuditorContactRecord' and keyvalue in (select id from  GB_AuditorContactRecord where TaskNo = N'715c535ad9a7447685ddc2a01c873fa4') delete from  GB_AuditorContactRecord where TaskNo = N'715c535ad9a7447685ddc2a01c873fa4' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'715c535ad9a7447685ddc2a01c873fa4') delete from  GB_ProjectPlanCombine where TaskNo = N'715c535ad9a7447685ddc2a01c873fa4' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from  GB_ProjectPlanTeam where TaskNo = N'715c535ad9a7447685ddc2a01c873fa4') delete from  GB_ProjectPlanTeam where TaskNo = N'715c535ad9a7447685ddc2a01c873fa4' DELETE FROM GB_ProjectPlan WHERE ID='512000754' DELETE FROM base_bizattach WHERE bizentityid='003002' and keyvalue='512000754' DELETE FROM base_bizColumnattach WHERE bizentityid='003002' and keyvalue='512000754' DELETE FROM base_bizattach WHERE bizentityid='008001' and keyvalue='512000754' DELETE FROM base_bizColumnattach WHERE bizentityid='008001' and keyvalue='512000754' DELETE FROM base_bizattach WHERE bizentityid='003003' and keyvalue='512000754' DELETE FROM base_bizColumnattach WHERE bizentityid='003003' and keyvalue='512000754' DELETE FROM base_bizattach WHERE bizentityid='003004' and keyvalue='512000754' DELETE FROM base_bizColumnattach WHERE bizentityid='003004' and keyvalue='512000754' DELETE FROM base_bizattach WHERE bizentityid='003005' and keyvalue='512000754' DELETE FROM base_bizColumnattach WHERE bizentityid='003005' and keyvalue='512000754' DELETE FROM base_bizattach WHERE bizentityid='006001' and keyvalue='512000754' DELETE FROM base_bizColumnattach WHERE bizentityid='006001' and keyvalue='512000754' DELETE FROM base_bizattach WHERE bizentityid='006002' and keyvalue='512000754' DELETE FROM base_bizColumnattach WHERE bizentityid='006002' and keyvalue='512000754' DELETE FROM base_bizattach WHERE bizentityid='006003' and keyvalue='512000754' DELETE FROM base_bizColumnattach WHERE bizentityid='006003' and keyvalue='512000754' DELETE FROM base_bizattach WHERE bizentityid='004003' and keyvalue='512000754' DELETE FROM base_bizColumnattach WHERE bizentityid='004003' and keyvalue='512000754' DELETE FROM base_bizattach WHERE bizentityid='004004' and keyvalue='512000754' DELETE FROM base_bizColumnattach WHERE bizentityid='004004' and keyvalue='512000754' DELETE FROM base_bizattach WHERE bizentityid='008002' and keyvalue='512000754' DELETE FROM base_bizColumnattach WHERE bizentityid='008002' and keyvalue='512000754' DELETE FROM base_bizattach WHERE bizentityid='003006' and keyvalue='512000754' DELETE FROM base_bizColumnattach WHERE bizentityid='003006' and keyvalue='512000754' DELETE FROM base_bizattach WHERE bizentityid='001035001' and keyvalue='512000754' DELETE FROM base_bizColumnattach WHERE bizentityid='001035001' and keyvalue='512000754' DELETE FROM base_bizattach WHERE bizentityid='003025' and keyvalue='512000754' DELETE FROM base_bizColumnattach WHERE bizentityid='003025' and keyvalue='512000754' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='003002' and rowid='512000754') DELETE FROM wf_workflowinstance where bizentityid='003002' and rowid='512000754' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='008001' and rowid='512000754') DELETE FROM wf_workflowinstance where bizentityid='008001' and rowid='512000754' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='003003' and rowid='512000754') DELETE FROM wf_workflowinstance where bizentityid='003003' and rowid='512000754' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='003004' and rowid='512000754') DELETE FROM wf_workflowinstance where bizentityid='003004' and rowid='512000754' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='003005' and rowid='512000754') DELETE FROM wf_workflowinstance where bizentityid='003005' and rowid='512000754' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='006001' and rowid='512000754') DELETE FROM wf_workflowinstance where bizentityid='006001' and rowid='512000754' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='006002' and rowid='512000754') DELETE FROM wf_workflowinstance where bizentityid='006002' and rowid='512000754' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='006003' and rowid='512000754') DELETE FROM wf_workflowinstance where bizentityid='006003' and rowid='512000754' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='004003' and rowid='512000754') DELETE FROM wf_workflowinstance where bizentityid='004003' and rowid='512000754' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='004004' and rowid='512000754') DELETE FROM wf_workflowinstance where bizentityid='004004' and rowid='512000754' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='008002' and rowid='512000754') DELETE FROM wf_workflowinstance where bizentityid='008002' and rowid='512000754' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='003006' and rowid='512000754') DELETE FROM wf_workflowinstance where bizentityid='003006' and rowid='512000754' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='001035001' and rowid='512000754') DELETE FROM wf_workflowinstance where bizentityid='001035001' and rowid='512000754' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='003025' and rowid='512000754') DELETE FROM wf_workflowinstance where bizentityid='003025' and rowid='512000754' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='003002' and rowid='512000754') DELETE FROM wf_bizflowinstance where bizentityid='003002' and rowid='512000754' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='008001' and rowid='512000754') DELETE FROM wf_bizflowinstance where bizentityid='008001' and rowid='512000754' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='003003' and rowid='512000754') DELETE FROM wf_bizflowinstance where bizentityid='003003' and rowid='512000754' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='003004' and rowid='512000754') DELETE FROM wf_bizflowinstance where bizentityid='003004' and rowid='512000754' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='003005' and rowid='512000754') DELETE FROM wf_bizflowinstance where bizentityid='003005' and rowid='512000754' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='006001' and rowid='512000754') DELETE FROM wf_bizflowinstance where bizentityid='006001' and rowid='512000754' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='006002' and rowid='512000754') DELETE FROM wf_bizflowinstance where bizentityid='006002' and rowid='512000754' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='006003' and rowid='512000754') DELETE FROM wf_bizflowinstance where bizentityid='006003' and rowid='512000754' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='004003' and rowid='512000754') DELETE FROM wf_bizflowinstance where bizentityid='004003' and rowid='512000754' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='004004' and rowid='512000754') DELETE FROM wf_bizflowinstance where bizentityid='004004' and rowid='512000754' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='008002' and rowid='512000754') DELETE FROM wf_bizflowinstance where bizentityid='008002' and rowid='512000754' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='003006' and rowid='512000754') DELETE FROM wf_bizflowinstance where bizentityid='003006' and rowid='512000754' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='001035001' and rowid='512000754') DELETE FROM wf_bizflowinstance where bizentityid='001035001' and rowid='512000754' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='003025' and rowid='512000754') DELETE FROM wf_bizflowinstance where bizentityid='003025' and rowid='512000754'

2025-12-08 17:12:18 执行时长：8.06秒 sql:DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCerti' and keyvalue in (select id from  GB_ProjectPlanCerti where ProjectNo = N'20983-2024-QEO-E') delete from  GB_ProjectPlanCerti where ProjectNo = N'20983-2024-QEO-E' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCerti' and keyvalue in (select id from  GB_ProjectPlanCerti where ProjectNo = N'20983-2024-QEO-E') delete from  GB_ProjectPlanCerti where ProjectNo = N'20983-2024-QEO-E' DELETE FROM base_bizColumnattach WHERE accesspath='GB_CertiDoc' and keyvalue in (select id from  GB_CertiDoc where ProjectNo = N'20983-2024-QEO-E') delete from  GB_CertiDoc where ProjectNo = N'20983-2024-QEO-E' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanEnergy' and keyvalue in (select id from  GB_ProjectPlanEnergy where PlanNo = N'20983-2024-QEO-E-100') delete from  GB_ProjectPlanEnergy where PlanNo = N'20983-2024-QEO-E-100' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from  GB_ProjectPlanTeam where TaskNo = N'715c535ad9a7447685ddc2a01c873fa4') delete from  GB_ProjectPlanTeam where TaskNo = N'715c535ad9a7447685ddc2a01c873fa4' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'715c535ad9a7447685ddc2a01c873fa4') delete from  GB_ProjectPlanCombine where TaskNo = N'715c535ad9a7447685ddc2a01c873fa4' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'715c535ad9a7447685ddc2a01c873fa4') delete from  GB_ProjectPlanCombine where TaskNo = N'715c535ad9a7447685ddc2a01c873fa4' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'715c535ad9a7447685ddc2a01c873fa4') delete from  GB_ProjectPlanCombine where TaskNo = N'715c535ad9a7447685ddc2a01c873fa4' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'715c535ad9a7447685ddc2a01c873fa4') delete from  GB_ProjectPlanCombine where TaskNo = N'715c535ad9a7447685ddc2a01c873fa4' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'715c535ad9a7447685ddc2a01c873fa4') delete from  GB_ProjectPlanCombine where TaskNo = N'715c535ad9a7447685ddc2a01c873fa4' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from  GB_ProjectPlanTeam where TaskNo = N'715c535ad9a7447685ddc2a01c873fa4') delete from  GB_ProjectPlanTeam where TaskNo = N'715c535ad9a7447685ddc2a01c873fa4' DELETE FROM base_bizColumnattach WHERE accesspath='GB_AuditProblem' and keyvalue in (select id from  GB_AuditProblem where TaskNo = N'715c535ad9a7447685ddc2a01c873fa4') delete from  GB_AuditProblem where TaskNo = N'715c535ad9a7447685ddc2a01c873fa4' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'715c535ad9a7447685ddc2a01c873fa4') delete from  GB_ProjectPlanCombine where TaskNo = N'715c535ad9a7447685ddc2a01c873fa4' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from  GB_ProjectPlanTeam where TaskNo = N'715c535ad9a7447685ddc2a01c873fa4') delete from  GB_ProjectPlanTeam where TaskNo = N'715c535ad9a7447685ddc2a01c873fa4' DELETE FROM base_bizColumnattach WHERE accesspath='GB_AuditProblem' and keyvalue in (select id from  GB_AuditProblem where TaskNo = N'715c535ad9a7447685ddc2a01c873fa4') delete from  GB_AuditProblem where TaskNo = N'715c535ad9a7447685ddc2a01c873fa4' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'715c535ad9a7447685ddc2a01c873fa4') delete from  GB_ProjectPlanCombine where TaskNo = N'715c535ad9a7447685ddc2a01c873fa4' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from  GB_ProjectPlanTeam where TaskNo = N'715c535ad9a7447685ddc2a01c873fa4') delete from  GB_ProjectPlanTeam where TaskNo = N'715c535ad9a7447685ddc2a01c873fa4' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'715c535ad9a7447685ddc2a01c873fa4') delete from  GB_ProjectPlanCombine where TaskNo = N'715c535ad9a7447685ddc2a01c873fa4' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'715c535ad9a7447685ddc2a01c873fa4') delete from  GB_ProjectPlanCombine where TaskNo = N'715c535ad9a7447685ddc2a01c873fa4' DELETE FROM base_bizColumnattach WHERE accesspath='GB_InvalidDoc' and keyvalue in (select id from  GB_InvalidDoc where TaskNo = N'715c535ad9a7447685ddc2a01c873fa4') delete from  GB_InvalidDoc where TaskNo = N'715c535ad9a7447685ddc2a01c873fa4' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from  GB_ProjectPlanTeam where TaskNo = N'715c535ad9a7447685ddc2a01c873fa4') delete from  GB_ProjectPlanTeam where TaskNo = N'715c535ad9a7447685ddc2a01c873fa4' DELETE FROM base_bizColumnattach WHERE accesspath='GB_AuditorContactRecord' and keyvalue in (select id from  GB_AuditorContactRecord where TaskNo = N'715c535ad9a7447685ddc2a01c873fa4') delete from  GB_AuditorContactRecord where TaskNo = N'715c535ad9a7447685ddc2a01c873fa4' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'715c535ad9a7447685ddc2a01c873fa4') delete from  GB_ProjectPlanCombine where TaskNo = N'715c535ad9a7447685ddc2a01c873fa4' DELETE FROM base_bizColumnattach WHERE accesspath='GB_AuditProblem' and keyvalue in (select id from  GB_AuditProblem where TaskNo = N'715c535ad9a7447685ddc2a01c873fa4') delete from  GB_AuditProblem where TaskNo = N'715c535ad9a7447685ddc2a01c873fa4' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from  GB_ProjectPlanTeam where TaskNo = N'715c535ad9a7447685ddc2a01c873fa4') delete from  GB_ProjectPlanTeam where TaskNo = N'715c535ad9a7447685ddc2a01c873fa4' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'715c535ad9a7447685ddc2a01c873fa4') delete from  GB_ProjectPlanCombine where TaskNo = N'715c535ad9a7447685ddc2a01c873fa4' DELETE FROM base_bizColumnattach WHERE accesspath='GB_AuditorContactRecord' and keyvalue in (select id from  GB_AuditorContactRecord where TaskNo = N'715c535ad9a7447685ddc2a01c873fa4') delete from  GB_AuditorContactRecord where TaskNo = N'715c535ad9a7447685ddc2a01c873fa4' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'715c535ad9a7447685ddc2a01c873fa4') delete from  GB_ProjectPlanCombine where TaskNo = N'715c535ad9a7447685ddc2a01c873fa4' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from  GB_ProjectPlanTeam where TaskNo = N'715c535ad9a7447685ddc2a01c873fa4') delete from  GB_ProjectPlanTeam where TaskNo = N'715c535ad9a7447685ddc2a01c873fa4' DELETE FROM GB_ProjectPlan WHERE ID='512000750' DELETE FROM base_bizattach WHERE bizentityid='003002' and keyvalue='512000750' DELETE FROM base_bizColumnattach WHERE bizentityid='003002' and keyvalue='512000750' DELETE FROM base_bizattach WHERE bizentityid='008001' and keyvalue='512000750' DELETE FROM base_bizColumnattach WHERE bizentityid='008001' and keyvalue='512000750' DELETE FROM base_bizattach WHERE bizentityid='003003' and keyvalue='512000750' DELETE FROM base_bizColumnattach WHERE bizentityid='003003' and keyvalue='512000750' DELETE FROM base_bizattach WHERE bizentityid='003004' and keyvalue='512000750' DELETE FROM base_bizColumnattach WHERE bizentityid='003004' and keyvalue='512000750' DELETE FROM base_bizattach WHERE bizentityid='003005' and keyvalue='512000750' DELETE FROM base_bizColumnattach WHERE bizentityid='003005' and keyvalue='512000750' DELETE FROM base_bizattach WHERE bizentityid='006001' and keyvalue='512000750' DELETE FROM base_bizColumnattach WHERE bizentityid='006001' and keyvalue='512000750' DELETE FROM base_bizattach WHERE bizentityid='006002' and keyvalue='512000750' DELETE FROM base_bizColumnattach WHERE bizentityid='006002' and keyvalue='512000750' DELETE FROM base_bizattach WHERE bizentityid='006003' and keyvalue='512000750' DELETE FROM base_bizColumnattach WHERE bizentityid='006003' and keyvalue='512000750' DELETE FROM base_bizattach WHERE bizentityid='004003' and keyvalue='512000750' DELETE FROM base_bizColumnattach WHERE bizentityid='004003' and keyvalue='512000750' DELETE FROM base_bizattach WHERE bizentityid='004004' and keyvalue='512000750' DELETE FROM base_bizColumnattach WHERE bizentityid='004004' and keyvalue='512000750' DELETE FROM base_bizattach WHERE bizentityid='008002' and keyvalue='512000750' DELETE FROM base_bizColumnattach WHERE bizentityid='008002' and keyvalue='512000750' DELETE FROM base_bizattach WHERE bizentityid='003006' and keyvalue='512000750' DELETE FROM base_bizColumnattach WHERE bizentityid='003006' and keyvalue='512000750' DELETE FROM base_bizattach WHERE bizentityid='001035001' and keyvalue='512000750' DELETE FROM base_bizColumnattach WHERE bizentityid='001035001' and keyvalue='512000750' DELETE FROM base_bizattach WHERE bizentityid='003025' and keyvalue='512000750' DELETE FROM base_bizColumnattach WHERE bizentityid='003025' and keyvalue='512000750' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='003002' and rowid='512000750') DELETE FROM wf_workflowinstance where bizentityid='003002' and rowid='512000750' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='008001' and rowid='512000750') DELETE FROM wf_workflowinstance where bizentityid='008001' and rowid='512000750' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='003003' and rowid='512000750') DELETE FROM wf_workflowinstance where bizentityid='003003' and rowid='512000750' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='003004' and rowid='512000750') DELETE FROM wf_workflowinstance where bizentityid='003004' and rowid='512000750' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='003005' and rowid='512000750') DELETE FROM wf_workflowinstance where bizentityid='003005' and rowid='512000750' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='006001' and rowid='512000750') DELETE FROM wf_workflowinstance where bizentityid='006001' and rowid='512000750' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='006002' and rowid='512000750') DELETE FROM wf_workflowinstance where bizentityid='006002' and rowid='512000750' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='006003' and rowid='512000750') DELETE FROM wf_workflowinstance where bizentityid='006003' and rowid='512000750' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='004003' and rowid='512000750') DELETE FROM wf_workflowinstance where bizentityid='004003' and rowid='512000750' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='004004' and rowid='512000750') DELETE FROM wf_workflowinstance where bizentityid='004004' and rowid='512000750' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='008002' and rowid='512000750') DELETE FROM wf_workflowinstance where bizentityid='008002' and rowid='512000750' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='003006' and rowid='512000750') DELETE FROM wf_workflowinstance where bizentityid='003006' and rowid='512000750' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='001035001' and rowid='512000750') DELETE FROM wf_workflowinstance where bizentityid='001035001' and rowid='512000750' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='003025' and rowid='512000750') DELETE FROM wf_workflowinstance where bizentityid='003025' and rowid='512000750' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='003002' and rowid='512000750') DELETE FROM wf_bizflowinstance where bizentityid='003002' and rowid='512000750' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='008001' and rowid='512000750') DELETE FROM wf_bizflowinstance where bizentityid='008001' and rowid='512000750' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='003003' and rowid='512000750') DELETE FROM wf_bizflowinstance where bizentityid='003003' and rowid='512000750' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='003004' and rowid='512000750') DELETE FROM wf_bizflowinstance where bizentityid='003004' and rowid='512000750' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='003005' and rowid='512000750') DELETE FROM wf_bizflowinstance where bizentityid='003005' and rowid='512000750' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='006001' and rowid='512000750') DELETE FROM wf_bizflowinstance where bizentityid='006001' and rowid='512000750' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='006002' and rowid='512000750') DELETE FROM wf_bizflowinstance where bizentityid='006002' and rowid='512000750' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='006003' and rowid='512000750') DELETE FROM wf_bizflowinstance where bizentityid='006003' and rowid='512000750' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='004003' and rowid='512000750') DELETE FROM wf_bizflowinstance where bizentityid='004003' and rowid='512000750' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='004004' and rowid='512000750') DELETE FROM wf_bizflowinstance where bizentityid='004004' and rowid='512000750' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='008002' and rowid='512000750') DELETE FROM wf_bizflowinstance where bizentityid='008002' and rowid='512000750' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='003006' and rowid='512000750') DELETE FROM wf_bizflowinstance where bizentityid='003006' and rowid='512000750' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='001035001' and rowid='512000750') DELETE FROM wf_bizflowinstance where bizentityid='001035001' and rowid='512000750' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='003025' and rowid='512000750') DELETE FROM wf_bizflowinstance where bizentityid='003025' and rowid='512000750'

2025-12-08 17:12:27 执行时长：7.48秒 sql:DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCerti' and keyvalue in (select id from  GB_ProjectPlanCerti where ProjectNo = N'20983-2024-QEO-Q') delete from  GB_ProjectPlanCerti where ProjectNo = N'20983-2024-QEO-Q' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCerti' and keyvalue in (select id from  GB_ProjectPlanCerti where ProjectNo = N'20983-2024-QEO-Q') delete from  GB_ProjectPlanCerti where ProjectNo = N'20983-2024-QEO-Q' DELETE FROM base_bizColumnattach WHERE accesspath='GB_CertiDoc' and keyvalue in (select id from  GB_CertiDoc where ProjectNo = N'20983-2024-QEO-Q') delete from  GB_CertiDoc where ProjectNo = N'20983-2024-QEO-Q' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanEnergy' and keyvalue in (select id from  GB_ProjectPlanEnergy where PlanNo = N'20983-2024-QEO-Q-100') delete from  GB_ProjectPlanEnergy where PlanNo = N'20983-2024-QEO-Q-100' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from  GB_ProjectPlanTeam where TaskNo = N'715c535ad9a7447685ddc2a01c873fa4') delete from  GB_ProjectPlanTeam where TaskNo = N'715c535ad9a7447685ddc2a01c873fa4' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'715c535ad9a7447685ddc2a01c873fa4') delete from  GB_ProjectPlanCombine where TaskNo = N'715c535ad9a7447685ddc2a01c873fa4' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'715c535ad9a7447685ddc2a01c873fa4') delete from  GB_ProjectPlanCombine where TaskNo = N'715c535ad9a7447685ddc2a01c873fa4' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'715c535ad9a7447685ddc2a01c873fa4') delete from  GB_ProjectPlanCombine where TaskNo = N'715c535ad9a7447685ddc2a01c873fa4' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'715c535ad9a7447685ddc2a01c873fa4') delete from  GB_ProjectPlanCombine where TaskNo = N'715c535ad9a7447685ddc2a01c873fa4' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'715c535ad9a7447685ddc2a01c873fa4') delete from  GB_ProjectPlanCombine where TaskNo = N'715c535ad9a7447685ddc2a01c873fa4' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from  GB_ProjectPlanTeam where TaskNo = N'715c535ad9a7447685ddc2a01c873fa4') delete from  GB_ProjectPlanTeam where TaskNo = N'715c535ad9a7447685ddc2a01c873fa4' DELETE FROM base_bizColumnattach WHERE accesspath='GB_AuditProblem' and keyvalue in (select id from  GB_AuditProblem where TaskNo = N'715c535ad9a7447685ddc2a01c873fa4') delete from  GB_AuditProblem where TaskNo = N'715c535ad9a7447685ddc2a01c873fa4' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'715c535ad9a7447685ddc2a01c873fa4') delete from  GB_ProjectPlanCombine where TaskNo = N'715c535ad9a7447685ddc2a01c873fa4' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from  GB_ProjectPlanTeam where TaskNo = N'715c535ad9a7447685ddc2a01c873fa4') delete from  GB_ProjectPlanTeam where TaskNo = N'715c535ad9a7447685ddc2a01c873fa4' DELETE FROM base_bizColumnattach WHERE accesspath='GB_AuditProblem' and keyvalue in (select id from  GB_AuditProblem where TaskNo = N'715c535ad9a7447685ddc2a01c873fa4') delete from  GB_AuditProblem where TaskNo = N'715c535ad9a7447685ddc2a01c873fa4' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'715c535ad9a7447685ddc2a01c873fa4') delete from  GB_ProjectPlanCombine where TaskNo = N'715c535ad9a7447685ddc2a01c873fa4' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from  GB_ProjectPlanTeam where TaskNo = N'715c535ad9a7447685ddc2a01c873fa4') delete from  GB_ProjectPlanTeam where TaskNo = N'715c535ad9a7447685ddc2a01c873fa4' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'715c535ad9a7447685ddc2a01c873fa4') delete from  GB_ProjectPlanCombine where TaskNo = N'715c535ad9a7447685ddc2a01c873fa4' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'715c535ad9a7447685ddc2a01c873fa4') delete from  GB_ProjectPlanCombine where TaskNo = N'715c535ad9a7447685ddc2a01c873fa4' DELETE FROM base_bizColumnattach WHERE accesspath='GB_InvalidDoc' and keyvalue in (select id from  GB_InvalidDoc where TaskNo = N'715c535ad9a7447685ddc2a01c873fa4') delete from  GB_InvalidDoc where TaskNo = N'715c535ad9a7447685ddc2a01c873fa4' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from  GB_ProjectPlanTeam where TaskNo = N'715c535ad9a7447685ddc2a01c873fa4') delete from  GB_ProjectPlanTeam where TaskNo = N'715c535ad9a7447685ddc2a01c873fa4' DELETE FROM base_bizColumnattach WHERE accesspath='GB_AuditorContactRecord' and keyvalue in (select id from  GB_AuditorContactRecord where TaskNo = N'715c535ad9a7447685ddc2a01c873fa4') delete from  GB_AuditorContactRecord where TaskNo = N'715c535ad9a7447685ddc2a01c873fa4' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'715c535ad9a7447685ddc2a01c873fa4') delete from  GB_ProjectPlanCombine where TaskNo = N'715c535ad9a7447685ddc2a01c873fa4' DELETE FROM base_bizColumnattach WHERE accesspath='GB_AuditProblem' and keyvalue in (select id from  GB_AuditProblem where TaskNo = N'715c535ad9a7447685ddc2a01c873fa4') delete from  GB_AuditProblem where TaskNo = N'715c535ad9a7447685ddc2a01c873fa4' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from  GB_ProjectPlanTeam where TaskNo = N'715c535ad9a7447685ddc2a01c873fa4') delete from  GB_ProjectPlanTeam where TaskNo = N'715c535ad9a7447685ddc2a01c873fa4' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'715c535ad9a7447685ddc2a01c873fa4') delete from  GB_ProjectPlanCombine where TaskNo = N'715c535ad9a7447685ddc2a01c873fa4' DELETE FROM base_bizColumnattach WHERE accesspath='GB_AuditorContactRecord' and keyvalue in (select id from  GB_AuditorContactRecord where TaskNo = N'715c535ad9a7447685ddc2a01c873fa4') delete from  GB_AuditorContactRecord where TaskNo = N'715c535ad9a7447685ddc2a01c873fa4' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'715c535ad9a7447685ddc2a01c873fa4') delete from  GB_ProjectPlanCombine where TaskNo = N'715c535ad9a7447685ddc2a01c873fa4' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from  GB_ProjectPlanTeam where TaskNo = N'715c535ad9a7447685ddc2a01c873fa4') delete from  GB_ProjectPlanTeam where TaskNo = N'715c535ad9a7447685ddc2a01c873fa4' DELETE FROM GB_ProjectPlan WHERE ID='512000752' DELETE FROM base_bizattach WHERE bizentityid='003002' and keyvalue='512000752' DELETE FROM base_bizColumnattach WHERE bizentityid='003002' and keyvalue='512000752' DELETE FROM base_bizattach WHERE bizentityid='008001' and keyvalue='512000752' DELETE FROM base_bizColumnattach WHERE bizentityid='008001' and keyvalue='512000752' DELETE FROM base_bizattach WHERE bizentityid='003003' and keyvalue='512000752' DELETE FROM base_bizColumnattach WHERE bizentityid='003003' and keyvalue='512000752' DELETE FROM base_bizattach WHERE bizentityid='003004' and keyvalue='512000752' DELETE FROM base_bizColumnattach WHERE bizentityid='003004' and keyvalue='512000752' DELETE FROM base_bizattach WHERE bizentityid='003005' and keyvalue='512000752' DELETE FROM base_bizColumnattach WHERE bizentityid='003005' and keyvalue='512000752' DELETE FROM base_bizattach WHERE bizentityid='006001' and keyvalue='512000752' DELETE FROM base_bizColumnattach WHERE bizentityid='006001' and keyvalue='512000752' DELETE FROM base_bizattach WHERE bizentityid='006002' and keyvalue='512000752' DELETE FROM base_bizColumnattach WHERE bizentityid='006002' and keyvalue='512000752' DELETE FROM base_bizattach WHERE bizentityid='006003' and keyvalue='512000752' DELETE FROM base_bizColumnattach WHERE bizentityid='006003' and keyvalue='512000752' DELETE FROM base_bizattach WHERE bizentityid='004003' and keyvalue='512000752' DELETE FROM base_bizColumnattach WHERE bizentityid='004003' and keyvalue='512000752' DELETE FROM base_bizattach WHERE bizentityid='004004' and keyvalue='512000752' DELETE FROM base_bizColumnattach WHERE bizentityid='004004' and keyvalue='512000752' DELETE FROM base_bizattach WHERE bizentityid='008002' and keyvalue='512000752' DELETE FROM base_bizColumnattach WHERE bizentityid='008002' and keyvalue='512000752' DELETE FROM base_bizattach WHERE bizentityid='003006' and keyvalue='512000752' DELETE FROM base_bizColumnattach WHERE bizentityid='003006' and keyvalue='512000752' DELETE FROM base_bizattach WHERE bizentityid='001035001' and keyvalue='512000752' DELETE FROM base_bizColumnattach WHERE bizentityid='001035001' and keyvalue='512000752' DELETE FROM base_bizattach WHERE bizentityid='003025' and keyvalue='512000752' DELETE FROM base_bizColumnattach WHERE bizentityid='003025' and keyvalue='512000752' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='003002' and rowid='512000752') DELETE FROM wf_workflowinstance where bizentityid='003002' and rowid='512000752' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='008001' and rowid='512000752') DELETE FROM wf_workflowinstance where bizentityid='008001' and rowid='512000752' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='003003' and rowid='512000752') DELETE FROM wf_workflowinstance where bizentityid='003003' and rowid='512000752' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='003004' and rowid='512000752') DELETE FROM wf_workflowinstance where bizentityid='003004' and rowid='512000752' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='003005' and rowid='512000752') DELETE FROM wf_workflowinstance where bizentityid='003005' and rowid='512000752' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='006001' and rowid='512000752') DELETE FROM wf_workflowinstance where bizentityid='006001' and rowid='512000752' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='006002' and rowid='512000752') DELETE FROM wf_workflowinstance where bizentityid='006002' and rowid='512000752' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='006003' and rowid='512000752') DELETE FROM wf_workflowinstance where bizentityid='006003' and rowid='512000752' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='004003' and rowid='512000752') DELETE FROM wf_workflowinstance where bizentityid='004003' and rowid='512000752' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='004004' and rowid='512000752') DELETE FROM wf_workflowinstance where bizentityid='004004' and rowid='512000752' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='008002' and rowid='512000752') DELETE FROM wf_workflowinstance where bizentityid='008002' and rowid='512000752' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='003006' and rowid='512000752') DELETE FROM wf_workflowinstance where bizentityid='003006' and rowid='512000752' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='001035001' and rowid='512000752') DELETE FROM wf_workflowinstance where bizentityid='001035001' and rowid='512000752' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='003025' and rowid='512000752') DELETE FROM wf_workflowinstance where bizentityid='003025' and rowid='512000752' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='003002' and rowid='512000752') DELETE FROM wf_bizflowinstance where bizentityid='003002' and rowid='512000752' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='008001' and rowid='512000752') DELETE FROM wf_bizflowinstance where bizentityid='008001' and rowid='512000752' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='003003' and rowid='512000752') DELETE FROM wf_bizflowinstance where bizentityid='003003' and rowid='512000752' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='003004' and rowid='512000752') DELETE FROM wf_bizflowinstance where bizentityid='003004' and rowid='512000752' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='003005' and rowid='512000752') DELETE FROM wf_bizflowinstance where bizentityid='003005' and rowid='512000752' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='006001' and rowid='512000752') DELETE FROM wf_bizflowinstance where bizentityid='006001' and rowid='512000752' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='006002' and rowid='512000752') DELETE FROM wf_bizflowinstance where bizentityid='006002' and rowid='512000752' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='006003' and rowid='512000752') DELETE FROM wf_bizflowinstance where bizentityid='006003' and rowid='512000752' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='004003' and rowid='512000752') DELETE FROM wf_bizflowinstance where bizentityid='004003' and rowid='512000752' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='004004' and rowid='512000752') DELETE FROM wf_bizflowinstance where bizentityid='004004' and rowid='512000752' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='008002' and rowid='512000752') DELETE FROM wf_bizflowinstance where bizentityid='008002' and rowid='512000752' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='003006' and rowid='512000752') DELETE FROM wf_bizflowinstance where bizentityid='003006' and rowid='512000752' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='001035001' and rowid='512000752') DELETE FROM wf_bizflowinstance where bizentityid='001035001' and rowid='512000752' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='003025' and rowid='512000752') DELETE FROM wf_bizflowinstance where bizentityid='003025' and rowid='512000752'

2025-12-08 17:12:27 执行时长：6.87秒 sql:delete from base_bizcolumnattach where AccessPath='GB_PlanDoc' and KeyValue='512006235' and DataColumnID='002202' insert into base_bizcolumnattach (id,bizentityid,keyvalue,DataColumnID,filename,createby,accesspath)  values ('200b41adae61d17a8ee','000020008','512006235','002202','ISC-A-08-1 B0审核信息传递表.docx','吴素平','GB_PlanDoc')

2025-12-08 17:12:36 执行时长：7.95秒 sql:DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCerti' and keyvalue in (select id from  GB_ProjectPlanCerti where ProjectNo = N'20983-2024-QEO-O') delete from  GB_ProjectPlanCerti where ProjectNo = N'20983-2024-QEO-O' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCerti' and keyvalue in (select id from  GB_ProjectPlanCerti where ProjectNo = N'20983-2024-QEO-O') delete from  GB_ProjectPlanCerti where ProjectNo = N'20983-2024-QEO-O' DELETE FROM base_bizColumnattach WHERE accesspath='GB_CertiDoc' and keyvalue in (select id from  GB_CertiDoc where ProjectNo = N'20983-2024-QEO-O') delete from  GB_CertiDoc where ProjectNo = N'20983-2024-QEO-O' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanEnergy' and keyvalue in (select id from  GB_ProjectPlanEnergy where PlanNo = N'20983-2024-QEO-O-200') delete from  GB_ProjectPlanEnergy where PlanNo = N'20983-2024-QEO-O-200' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from  GB_ProjectPlanTeam where TaskNo = N'775167bfda684a56bd7e9a45d8008bac') delete from  GB_ProjectPlanTeam where TaskNo = N'775167bfda684a56bd7e9a45d8008bac' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'775167bfda684a56bd7e9a45d8008bac') delete from  GB_ProjectPlanCombine where TaskNo = N'775167bfda684a56bd7e9a45d8008bac' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'775167bfda684a56bd7e9a45d8008bac') delete from  GB_ProjectPlanCombine where TaskNo = N'775167bfda684a56bd7e9a45d8008bac' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'775167bfda684a56bd7e9a45d8008bac') delete from  GB_ProjectPlanCombine where TaskNo = N'775167bfda684a56bd7e9a45d8008bac' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'775167bfda684a56bd7e9a45d8008bac') delete from  GB_ProjectPlanCombine where TaskNo = N'775167bfda684a56bd7e9a45d8008bac' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'775167bfda684a56bd7e9a45d8008bac') delete from  GB_ProjectPlanCombine where TaskNo = N'775167bfda684a56bd7e9a45d8008bac' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from  GB_ProjectPlanTeam where TaskNo = N'775167bfda684a56bd7e9a45d8008bac') delete from  GB_ProjectPlanTeam where TaskNo = N'775167bfda684a56bd7e9a45d8008bac' DELETE FROM base_bizColumnattach WHERE accesspath='GB_AuditProblem' and keyvalue in (select id from  GB_AuditProblem where TaskNo = N'775167bfda684a56bd7e9a45d8008bac') delete from  GB_AuditProblem where TaskNo = N'775167bfda684a56bd7e9a45d8008bac' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'775167bfda684a56bd7e9a45d8008bac') delete from  GB_ProjectPlanCombine where TaskNo = N'775167bfda684a56bd7e9a45d8008bac' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from  GB_ProjectPlanTeam where TaskNo = N'775167bfda684a56bd7e9a45d8008bac') delete from  GB_ProjectPlanTeam where TaskNo = N'775167bfda684a56bd7e9a45d8008bac' DELETE FROM base_bizColumnattach WHERE accesspath='GB_AuditProblem' and keyvalue in (select id from  GB_AuditProblem where TaskNo = N'775167bfda684a56bd7e9a45d8008bac') delete from  GB_AuditProblem where TaskNo = N'775167bfda684a56bd7e9a45d8008bac' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'775167bfda684a56bd7e9a45d8008bac') delete from  GB_ProjectPlanCombine where TaskNo = N'775167bfda684a56bd7e9a45d8008bac' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from  GB_ProjectPlanTeam where TaskNo = N'775167bfda684a56bd7e9a45d8008bac') delete from  GB_ProjectPlanTeam where TaskNo = N'775167bfda684a56bd7e9a45d8008bac' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'775167bfda684a56bd7e9a45d8008bac') delete from  GB_ProjectPlanCombine where TaskNo = N'775167bfda684a56bd7e9a45d8008bac' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'775167bfda684a56bd7e9a45d8008bac') delete from  GB_ProjectPlanCombine where TaskNo = N'775167bfda684a56bd7e9a45d8008bac' DELETE FROM base_bizColumnattach WHERE accesspath='GB_InvalidDoc' and keyvalue in (select id from  GB_InvalidDoc where TaskNo = N'775167bfda684a56bd7e9a45d8008bac') delete from  GB_InvalidDoc where TaskNo = N'775167bfda684a56bd7e9a45d8008bac' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from  GB_ProjectPlanTeam where TaskNo = N'775167bfda684a56bd7e9a45d8008bac') delete from  GB_ProjectPlanTeam where TaskNo = N'775167bfda684a56bd7e9a45d8008bac' DELETE FROM base_bizColumnattach WHERE accesspath='GB_AuditorContactRecord' and keyvalue in (select id from  GB_AuditorContactRecord where TaskNo = N'775167bfda684a56bd7e9a45d8008bac') delete from  GB_AuditorContactRecord where TaskNo = N'775167bfda684a56bd7e9a45d8008bac' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'775167bfda684a56bd7e9a45d8008bac') delete from  GB_ProjectPlanCombine where TaskNo = N'775167bfda684a56bd7e9a45d8008bac' DELETE FROM base_bizColumnattach WHERE accesspath='GB_AuditProblem' and keyvalue in (select id from  GB_AuditProblem where TaskNo = N'775167bfda684a56bd7e9a45d8008bac') delete from  GB_AuditProblem where TaskNo = N'775167bfda684a56bd7e9a45d8008bac' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from  GB_ProjectPlanTeam where TaskNo = N'775167bfda684a56bd7e9a45d8008bac') delete from  GB_ProjectPlanTeam where TaskNo = N'775167bfda684a56bd7e9a45d8008bac' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'775167bfda684a56bd7e9a45d8008bac') delete from  GB_ProjectPlanCombine where TaskNo = N'775167bfda684a56bd7e9a45d8008bac' DELETE FROM base_bizColumnattach WHERE accesspath='GB_AuditorContactRecord' and keyvalue in (select id from  GB_AuditorContactRecord where TaskNo = N'775167bfda684a56bd7e9a45d8008bac') delete from  GB_AuditorContactRecord where TaskNo = N'775167bfda684a56bd7e9a45d8008bac' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'775167bfda684a56bd7e9a45d8008bac') delete from  GB_ProjectPlanCombine where TaskNo = N'775167bfda684a56bd7e9a45d8008bac' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from  GB_ProjectPlanTeam where TaskNo = N'775167bfda684a56bd7e9a45d8008bac') delete from  GB_ProjectPlanTeam where TaskNo = N'775167bfda684a56bd7e9a45d8008bac' DELETE FROM GB_ProjectPlan WHERE ID='512000753' DELETE FROM base_bizattach WHERE bizentityid='003002' and keyvalue='512000753' DELETE FROM base_bizColumnattach WHERE bizentityid='003002' and keyvalue='512000753' DELETE FROM base_bizattach WHERE bizentityid='008001' and keyvalue='512000753' DELETE FROM base_bizColumnattach WHERE bizentityid='008001' and keyvalue='512000753' DELETE FROM base_bizattach WHERE bizentityid='003003' and keyvalue='512000753' DELETE FROM base_bizColumnattach WHERE bizentityid='003003' and keyvalue='512000753' DELETE FROM base_bizattach WHERE bizentityid='003004' and keyvalue='512000753' DELETE FROM base_bizColumnattach WHERE bizentityid='003004' and keyvalue='512000753' DELETE FROM base_bizattach WHERE bizentityid='003005' and keyvalue='512000753' DELETE FROM base_bizColumnattach WHERE bizentityid='003005' and keyvalue='512000753' DELETE FROM base_bizattach WHERE bizentityid='006001' and keyvalue='512000753' DELETE FROM base_bizColumnattach WHERE bizentityid='006001' and keyvalue='512000753' DELETE FROM base_bizattach WHERE bizentityid='006002' and keyvalue='512000753' DELETE FROM base_bizColumnattach WHERE bizentityid='006002' and keyvalue='512000753' DELETE FROM base_bizattach WHERE bizentityid='006003' and keyvalue='512000753' DELETE FROM base_bizColumnattach WHERE bizentityid='006003' and keyvalue='512000753' DELETE FROM base_bizattach WHERE bizentityid='004003' and keyvalue='512000753' DELETE FROM base_bizColumnattach WHERE bizentityid='004003' and keyvalue='512000753' DELETE FROM base_bizattach WHERE bizentityid='004004' and keyvalue='512000753' DELETE FROM base_bizColumnattach WHERE bizentityid='004004' and keyvalue='512000753' DELETE FROM base_bizattach WHERE bizentityid='008002' and keyvalue='512000753' DELETE FROM base_bizColumnattach WHERE bizentityid='008002' and keyvalue='512000753' DELETE FROM base_bizattach WHERE bizentityid='003006' and keyvalue='512000753' DELETE FROM base_bizColumnattach WHERE bizentityid='003006' and keyvalue='512000753' DELETE FROM base_bizattach WHERE bizentityid='001035001' and keyvalue='512000753' DELETE FROM base_bizColumnattach WHERE bizentityid='001035001' and keyvalue='512000753' DELETE FROM base_bizattach WHERE bizentityid='003025' and keyvalue='512000753' DELETE FROM base_bizColumnattach WHERE bizentityid='003025' and keyvalue='512000753' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='003002' and rowid='512000753') DELETE FROM wf_workflowinstance where bizentityid='003002' and rowid='512000753' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='008001' and rowid='512000753') DELETE FROM wf_workflowinstance where bizentityid='008001' and rowid='512000753' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='003003' and rowid='512000753') DELETE FROM wf_workflowinstance where bizentityid='003003' and rowid='512000753' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='003004' and rowid='512000753') DELETE FROM wf_workflowinstance where bizentityid='003004' and rowid='512000753' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='003005' and rowid='512000753') DELETE FROM wf_workflowinstance where bizentityid='003005' and rowid='512000753' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='006001' and rowid='512000753') DELETE FROM wf_workflowinstance where bizentityid='006001' and rowid='512000753' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='006002' and rowid='512000753') DELETE FROM wf_workflowinstance where bizentityid='006002' and rowid='512000753' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='006003' and rowid='512000753') DELETE FROM wf_workflowinstance where bizentityid='006003' and rowid='512000753' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='004003' and rowid='512000753') DELETE FROM wf_workflowinstance where bizentityid='004003' and rowid='512000753' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='004004' and rowid='512000753') DELETE FROM wf_workflowinstance where bizentityid='004004' and rowid='512000753' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='008002' and rowid='512000753') DELETE FROM wf_workflowinstance where bizentityid='008002' and rowid='512000753' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='003006' and rowid='512000753') DELETE FROM wf_workflowinstance where bizentityid='003006' and rowid='512000753' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='001035001' and rowid='512000753') DELETE FROM wf_workflowinstance where bizentityid='001035001' and rowid='512000753' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='003025' and rowid='512000753') DELETE FROM wf_workflowinstance where bizentityid='003025' and rowid='512000753' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='003002' and rowid='512000753') DELETE FROM wf_bizflowinstance where bizentityid='003002' and rowid='512000753' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='008001' and rowid='512000753') DELETE FROM wf_bizflowinstance where bizentityid='008001' and rowid='512000753' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='003003' and rowid='512000753') DELETE FROM wf_bizflowinstance where bizentityid='003003' and rowid='512000753' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='003004' and rowid='512000753') DELETE FROM wf_bizflowinstance where bizentityid='003004' and rowid='512000753' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='003005' and rowid='512000753') DELETE FROM wf_bizflowinstance where bizentityid='003005' and rowid='512000753' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='006001' and rowid='512000753') DELETE FROM wf_bizflowinstance where bizentityid='006001' and rowid='512000753' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='006002' and rowid='512000753') DELETE FROM wf_bizflowinstance where bizentityid='006002' and rowid='512000753' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='006003' and rowid='512000753') DELETE FROM wf_bizflowinstance where bizentityid='006003' and rowid='512000753' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='004003' and rowid='512000753') DELETE FROM wf_bizflowinstance where bizentityid='004003' and rowid='512000753' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='004004' and rowid='512000753') DELETE FROM wf_bizflowinstance where bizentityid='004004' and rowid='512000753' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='008002' and rowid='512000753') DELETE FROM wf_bizflowinstance where bizentityid='008002' and rowid='512000753' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='003006' and rowid='512000753') DELETE FROM wf_bizflowinstance where bizentityid='003006' and rowid='512000753' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='001035001' and rowid='512000753') DELETE FROM wf_bizflowinstance where bizentityid='001035001' and rowid='512000753' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='003025' and rowid='512000753') DELETE FROM wf_bizflowinstance where bizentityid='003025' and rowid='512000753'

2025-12-08 17:12:47 执行时长：10秒 sql:DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCerti' and keyvalue in (select id from  GB_ProjectPlanCerti where ProjectNo = N'20983-2024-QEO-Q') delete from  GB_ProjectPlanCerti where ProjectNo = N'20983-2024-QEO-Q' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCerti' and keyvalue in (select id from  GB_ProjectPlanCerti where ProjectNo = N'20983-2024-QEO-Q') delete from  GB_ProjectPlanCerti where ProjectNo = N'20983-2024-QEO-Q' DELETE FROM base_bizColumnattach WHERE accesspath='GB_CertiDoc' and keyvalue in (select id from  GB_CertiDoc where ProjectNo = N'20983-2024-QEO-Q') delete from  GB_CertiDoc where ProjectNo = N'20983-2024-QEO-Q' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanEnergy' and keyvalue in (select id from  GB_ProjectPlanEnergy where PlanNo = N'20983-2024-QEO-Q-200') delete from  GB_ProjectPlanEnergy where PlanNo = N'20983-2024-QEO-Q-200' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from  GB_ProjectPlanTeam where TaskNo = N'775167bfda684a56bd7e9a45d8008bac') delete from  GB_ProjectPlanTeam where TaskNo = N'775167bfda684a56bd7e9a45d8008bac' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'775167bfda684a56bd7e9a45d8008bac') delete from  GB_ProjectPlanCombine where TaskNo = N'775167bfda684a56bd7e9a45d8008bac' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'775167bfda684a56bd7e9a45d8008bac') delete from  GB_ProjectPlanCombine where TaskNo = N'775167bfda684a56bd7e9a45d8008bac' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'775167bfda684a56bd7e9a45d8008bac') delete from  GB_ProjectPlanCombine where TaskNo = N'775167bfda684a56bd7e9a45d8008bac' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'775167bfda684a56bd7e9a45d8008bac') delete from  GB_ProjectPlanCombine where TaskNo = N'775167bfda684a56bd7e9a45d8008bac' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'775167bfda684a56bd7e9a45d8008bac') delete from  GB_ProjectPlanCombine where TaskNo = N'775167bfda684a56bd7e9a45d8008bac' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from  GB_ProjectPlanTeam where TaskNo = N'775167bfda684a56bd7e9a45d8008bac') delete from  GB_ProjectPlanTeam where TaskNo = N'775167bfda684a56bd7e9a45d8008bac' DELETE FROM base_bizColumnattach WHERE accesspath='GB_AuditProblem' and keyvalue in (select id from  GB_AuditProblem where TaskNo = N'775167bfda684a56bd7e9a45d8008bac') delete from  GB_AuditProblem where TaskNo = N'775167bfda684a56bd7e9a45d8008bac' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'775167bfda684a56bd7e9a45d8008bac') delete from  GB_ProjectPlanCombine where TaskNo = N'775167bfda684a56bd7e9a45d8008bac' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from  GB_ProjectPlanTeam where TaskNo = N'775167bfda684a56bd7e9a45d8008bac') delete from  GB_ProjectPlanTeam where TaskNo = N'775167bfda684a56bd7e9a45d8008bac' DELETE FROM base_bizColumnattach WHERE accesspath='GB_AuditProblem' and keyvalue in (select id from  GB_AuditProblem where TaskNo = N'775167bfda684a56bd7e9a45d8008bac') delete from  GB_AuditProblem where TaskNo = N'775167bfda684a56bd7e9a45d8008bac' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'775167bfda684a56bd7e9a45d8008bac') delete from  GB_ProjectPlanCombine where TaskNo = N'775167bfda684a56bd7e9a45d8008bac' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from  GB_ProjectPlanTeam where TaskNo = N'775167bfda684a56bd7e9a45d8008bac') delete from  GB_ProjectPlanTeam where TaskNo = N'775167bfda684a56bd7e9a45d8008bac' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'775167bfda684a56bd7e9a45d8008bac') delete from  GB_ProjectPlanCombine where TaskNo = N'775167bfda684a56bd7e9a45d8008bac' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'775167bfda684a56bd7e9a45d8008bac') delete from  GB_ProjectPlanCombine where TaskNo = N'775167bfda684a56bd7e9a45d8008bac' DELETE FROM base_bizColumnattach WHERE accesspath='GB_InvalidDoc' and keyvalue in (select id from  GB_InvalidDoc where TaskNo = N'775167bfda684a56bd7e9a45d8008bac') delete from  GB_InvalidDoc where TaskNo = N'775167bfda684a56bd7e9a45d8008bac' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from  GB_ProjectPlanTeam where TaskNo = N'775167bfda684a56bd7e9a45d8008bac') delete from  GB_ProjectPlanTeam where TaskNo = N'775167bfda684a56bd7e9a45d8008bac' DELETE FROM base_bizColumnattach WHERE accesspath='GB_AuditorContactRecord' and keyvalue in (select id from  GB_AuditorContactRecord where TaskNo = N'775167bfda684a56bd7e9a45d8008bac') delete from  GB_AuditorContactRecord where TaskNo = N'775167bfda684a56bd7e9a45d8008bac' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'775167bfda684a56bd7e9a45d8008bac') delete from  GB_ProjectPlanCombine where TaskNo = N'775167bfda684a56bd7e9a45d8008bac' DELETE FROM base_bizColumnattach WHERE accesspath='GB_AuditProblem' and keyvalue in (select id from  GB_AuditProblem where TaskNo = N'775167bfda684a56bd7e9a45d8008bac') delete from  GB_AuditProblem where TaskNo = N'775167bfda684a56bd7e9a45d8008bac' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from  GB_ProjectPlanTeam where TaskNo = N'775167bfda684a56bd7e9a45d8008bac') delete from  GB_ProjectPlanTeam where TaskNo = N'775167bfda684a56bd7e9a45d8008bac' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'775167bfda684a56bd7e9a45d8008bac') delete from  GB_ProjectPlanCombine where TaskNo = N'775167bfda684a56bd7e9a45d8008bac' DELETE FROM base_bizColumnattach WHERE accesspath='GB_AuditorContactRecord' and keyvalue in (select id from  GB_AuditorContactRecord where TaskNo = N'775167bfda684a56bd7e9a45d8008bac') delete from  GB_AuditorContactRecord where TaskNo = N'775167bfda684a56bd7e9a45d8008bac' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'775167bfda684a56bd7e9a45d8008bac') delete from  GB_ProjectPlanCombine where TaskNo = N'775167bfda684a56bd7e9a45d8008bac' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from  GB_ProjectPlanTeam where TaskNo = N'775167bfda684a56bd7e9a45d8008bac') delete from  GB_ProjectPlanTeam where TaskNo = N'775167bfda684a56bd7e9a45d8008bac' DELETE FROM GB_ProjectPlan WHERE ID='512000751' DELETE FROM base_bizattach WHERE bizentityid='003002' and keyvalue='512000751' DELETE FROM base_bizColumnattach WHERE bizentityid='003002' and keyvalue='512000751' DELETE FROM base_bizattach WHERE bizentityid='008001' and keyvalue='512000751' DELETE FROM base_bizColumnattach WHERE bizentityid='008001' and keyvalue='512000751' DELETE FROM base_bizattach WHERE bizentityid='003003' and keyvalue='512000751' DELETE FROM base_bizColumnattach WHERE bizentityid='003003' and keyvalue='512000751' DELETE FROM base_bizattach WHERE bizentityid='003004' and keyvalue='512000751' DELETE FROM base_bizColumnattach WHERE bizentityid='003004' and keyvalue='512000751' DELETE FROM base_bizattach WHERE bizentityid='003005' and keyvalue='512000751' DELETE FROM base_bizColumnattach WHERE bizentityid='003005' and keyvalue='512000751' DELETE FROM base_bizattach WHERE bizentityid='006001' and keyvalue='512000751' DELETE FROM base_bizColumnattach WHERE bizentityid='006001' and keyvalue='512000751' DELETE FROM base_bizattach WHERE bizentityid='006002' and keyvalue='512000751' DELETE FROM base_bizColumnattach WHERE bizentityid='006002' and keyvalue='512000751' DELETE FROM base_bizattach WHERE bizentityid='006003' and keyvalue='512000751' DELETE FROM base_bizColumnattach WHERE bizentityid='006003' and keyvalue='512000751' DELETE FROM base_bizattach WHERE bizentityid='004003' and keyvalue='512000751' DELETE FROM base_bizColumnattach WHERE bizentityid='004003' and keyvalue='512000751' DELETE FROM base_bizattach WHERE bizentityid='004004' and keyvalue='512000751' DELETE FROM base_bizColumnattach WHERE bizentityid='004004' and keyvalue='512000751' DELETE FROM base_bizattach WHERE bizentityid='008002' and keyvalue='512000751' DELETE FROM base_bizColumnattach WHERE bizentityid='008002' and keyvalue='512000751' DELETE FROM base_bizattach WHERE bizentityid='003006' and keyvalue='512000751' DELETE FROM base_bizColumnattach WHERE bizentityid='003006' and keyvalue='512000751' DELETE FROM base_bizattach WHERE bizentityid='001035001' and keyvalue='512000751' DELETE FROM base_bizColumnattach WHERE bizentityid='001035001' and keyvalue='512000751' DELETE FROM base_bizattach WHERE bizentityid='003025' and keyvalue='512000751' DELETE FROM base_bizColumnattach WHERE bizentityid='003025' and keyvalue='512000751' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='003002' and rowid='512000751') DELETE FROM wf_workflowinstance where bizentityid='003002' and rowid='512000751' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='008001' and rowid='512000751') DELETE FROM wf_workflowinstance where bizentityid='008001' and rowid='512000751' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='003003' and rowid='512000751') DELETE FROM wf_workflowinstance where bizentityid='003003' and rowid='512000751' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='003004' and rowid='512000751') DELETE FROM wf_workflowinstance where bizentityid='003004' and rowid='512000751' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='003005' and rowid='512000751') DELETE FROM wf_workflowinstance where bizentityid='003005' and rowid='512000751' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='006001' and rowid='512000751') DELETE FROM wf_workflowinstance where bizentityid='006001' and rowid='512000751' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='006002' and rowid='512000751') DELETE FROM wf_workflowinstance where bizentityid='006002' and rowid='512000751' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='006003' and rowid='512000751') DELETE FROM wf_workflowinstance where bizentityid='006003' and rowid='512000751' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='004003' and rowid='512000751') DELETE FROM wf_workflowinstance where bizentityid='004003' and rowid='512000751' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='004004' and rowid='512000751') DELETE FROM wf_workflowinstance where bizentityid='004004' and rowid='512000751' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='008002' and rowid='512000751') DELETE FROM wf_workflowinstance where bizentityid='008002' and rowid='512000751' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='003006' and rowid='512000751') DELETE FROM wf_workflowinstance where bizentityid='003006' and rowid='512000751' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='001035001' and rowid='512000751') DELETE FROM wf_workflowinstance where bizentityid='001035001' and rowid='512000751' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='003025' and rowid='512000751') DELETE FROM wf_workflowinstance where bizentityid='003025' and rowid='512000751' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='003002' and rowid='512000751') DELETE FROM wf_bizflowinstance where bizentityid='003002' and rowid='512000751' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='008001' and rowid='512000751') DELETE FROM wf_bizflowinstance where bizentityid='008001' and rowid='512000751' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='003003' and rowid='512000751') DELETE FROM wf_bizflowinstance where bizentityid='003003' and rowid='512000751' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='003004' and rowid='512000751') DELETE FROM wf_bizflowinstance where bizentityid='003004' and rowid='512000751' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='003005' and rowid='512000751') DELETE FROM wf_bizflowinstance where bizentityid='003005' and rowid='512000751' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='006001' and rowid='512000751') DELETE FROM wf_bizflowinstance where bizentityid='006001' and rowid='512000751' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='006002' and rowid='512000751') DELETE FROM wf_bizflowinstance where bizentityid='006002' and rowid='512000751' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='006003' and rowid='512000751') DELETE FROM wf_bizflowinstance where bizentityid='006003' and rowid='512000751' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='004003' and rowid='512000751') DELETE FROM wf_bizflowinstance where bizentityid='004003' and rowid='512000751' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='004004' and rowid='512000751') DELETE FROM wf_bizflowinstance where bizentityid='004004' and rowid='512000751' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='008002' and rowid='512000751') DELETE FROM wf_bizflowinstance where bizentityid='008002' and rowid='512000751' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='003006' and rowid='512000751') DELETE FROM wf_bizflowinstance where bizentityid='003006' and rowid='512000751' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='001035001' and rowid='512000751') DELETE FROM wf_bizflowinstance where bizentityid='001035001' and rowid='512000751' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='003025' and rowid='512000751') DELETE FROM wf_bizflowinstance where bizentityid='003025' and rowid='512000751'

2025-12-08 17:12:54 执行时长：7.41秒 sql:DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCerti' and keyvalue in (select id from  GB_ProjectPlanCerti where ProjectNo = N'20983-2024-QEO-E') delete from  GB_ProjectPlanCerti where ProjectNo = N'20983-2024-QEO-E' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCerti' and keyvalue in (select id from  GB_ProjectPlanCerti where ProjectNo = N'20983-2024-QEO-E') delete from  GB_ProjectPlanCerti where ProjectNo = N'20983-2024-QEO-E' DELETE FROM base_bizColumnattach WHERE accesspath='GB_CertiDoc' and keyvalue in (select id from  GB_CertiDoc where ProjectNo = N'20983-2024-QEO-E') delete from  GB_CertiDoc where ProjectNo = N'20983-2024-QEO-E' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanEnergy' and keyvalue in (select id from  GB_ProjectPlanEnergy where PlanNo = N'20983-2024-QEO-E-200') delete from  GB_ProjectPlanEnergy where PlanNo = N'20983-2024-QEO-E-200' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from  GB_ProjectPlanTeam where TaskNo = N'775167bfda684a56bd7e9a45d8008bac') delete from  GB_ProjectPlanTeam where TaskNo = N'775167bfda684a56bd7e9a45d8008bac' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'775167bfda684a56bd7e9a45d8008bac') delete from  GB_ProjectPlanCombine where TaskNo = N'775167bfda684a56bd7e9a45d8008bac' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'775167bfda684a56bd7e9a45d8008bac') delete from  GB_ProjectPlanCombine where TaskNo = N'775167bfda684a56bd7e9a45d8008bac' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'775167bfda684a56bd7e9a45d8008bac') delete from  GB_ProjectPlanCombine where TaskNo = N'775167bfda684a56bd7e9a45d8008bac' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'775167bfda684a56bd7e9a45d8008bac') delete from  GB_ProjectPlanCombine where TaskNo = N'775167bfda684a56bd7e9a45d8008bac' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'775167bfda684a56bd7e9a45d8008bac') delete from  GB_ProjectPlanCombine where TaskNo = N'775167bfda684a56bd7e9a45d8008bac' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from  GB_ProjectPlanTeam where TaskNo = N'775167bfda684a56bd7e9a45d8008bac') delete from  GB_ProjectPlanTeam where TaskNo = N'775167bfda684a56bd7e9a45d8008bac' DELETE FROM base_bizColumnattach WHERE accesspath='GB_AuditProblem' and keyvalue in (select id from  GB_AuditProblem where TaskNo = N'775167bfda684a56bd7e9a45d8008bac') delete from  GB_AuditProblem where TaskNo = N'775167bfda684a56bd7e9a45d8008bac' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'775167bfda684a56bd7e9a45d8008bac') delete from  GB_ProjectPlanCombine where TaskNo = N'775167bfda684a56bd7e9a45d8008bac' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from  GB_ProjectPlanTeam where TaskNo = N'775167bfda684a56bd7e9a45d8008bac') delete from  GB_ProjectPlanTeam where TaskNo = N'775167bfda684a56bd7e9a45d8008bac' DELETE FROM base_bizColumnattach WHERE accesspath='GB_AuditProblem' and keyvalue in (select id from  GB_AuditProblem where TaskNo = N'775167bfda684a56bd7e9a45d8008bac') delete from  GB_AuditProblem where TaskNo = N'775167bfda684a56bd7e9a45d8008bac' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'775167bfda684a56bd7e9a45d8008bac') delete from  GB_ProjectPlanCombine where TaskNo = N'775167bfda684a56bd7e9a45d8008bac' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from  GB_ProjectPlanTeam where TaskNo = N'775167bfda684a56bd7e9a45d8008bac') delete from  GB_ProjectPlanTeam where TaskNo = N'775167bfda684a56bd7e9a45d8008bac' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'775167bfda684a56bd7e9a45d8008bac') delete from  GB_ProjectPlanCombine where TaskNo = N'775167bfda684a56bd7e9a45d8008bac' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'775167bfda684a56bd7e9a45d8008bac') delete from  GB_ProjectPlanCombine where TaskNo = N'775167bfda684a56bd7e9a45d8008bac' DELETE FROM base_bizColumnattach WHERE accesspath='GB_InvalidDoc' and keyvalue in (select id from  GB_InvalidDoc where TaskNo = N'775167bfda684a56bd7e9a45d8008bac') delete from  GB_InvalidDoc where TaskNo = N'775167bfda684a56bd7e9a45d8008bac' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from  GB_ProjectPlanTeam where TaskNo = N'775167bfda684a56bd7e9a45d8008bac') delete from  GB_ProjectPlanTeam where TaskNo = N'775167bfda684a56bd7e9a45d8008bac' DELETE FROM base_bizColumnattach WHERE accesspath='GB_AuditorContactRecord' and keyvalue in (select id from  GB_AuditorContactRecord where TaskNo = N'775167bfda684a56bd7e9a45d8008bac') delete from  GB_AuditorContactRecord where TaskNo = N'775167bfda684a56bd7e9a45d8008bac' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'775167bfda684a56bd7e9a45d8008bac') delete from  GB_ProjectPlanCombine where TaskNo = N'775167bfda684a56bd7e9a45d8008bac' DELETE FROM base_bizColumnattach WHERE accesspath='GB_AuditProblem' and keyvalue in (select id from  GB_AuditProblem where TaskNo = N'775167bfda684a56bd7e9a45d8008bac') delete from  GB_AuditProblem where TaskNo = N'775167bfda684a56bd7e9a45d8008bac' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from  GB_ProjectPlanTeam where TaskNo = N'775167bfda684a56bd7e9a45d8008bac') delete from  GB_ProjectPlanTeam where TaskNo = N'775167bfda684a56bd7e9a45d8008bac' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'775167bfda684a56bd7e9a45d8008bac') delete from  GB_ProjectPlanCombine where TaskNo = N'775167bfda684a56bd7e9a45d8008bac' DELETE FROM base_bizColumnattach WHERE accesspath='GB_AuditorContactRecord' and keyvalue in (select id from  GB_AuditorContactRecord where TaskNo = N'775167bfda684a56bd7e9a45d8008bac') delete from  GB_AuditorContactRecord where TaskNo = N'775167bfda684a56bd7e9a45d8008bac' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'775167bfda684a56bd7e9a45d8008bac') delete from  GB_ProjectPlanCombine where TaskNo = N'775167bfda684a56bd7e9a45d8008bac' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from  GB_ProjectPlanTeam where TaskNo = N'775167bfda684a56bd7e9a45d8008bac') delete from  GB_ProjectPlanTeam where TaskNo = N'775167bfda684a56bd7e9a45d8008bac' DELETE FROM GB_ProjectPlan WHERE ID='512000749' DELETE FROM base_bizattach WHERE bizentityid='003002' and keyvalue='512000749' DELETE FROM base_bizColumnattach WHERE bizentityid='003002' and keyvalue='512000749' DELETE FROM base_bizattach WHERE bizentityid='008001' and keyvalue='512000749' DELETE FROM base_bizColumnattach WHERE bizentityid='008001' and keyvalue='512000749' DELETE FROM base_bizattach WHERE bizentityid='003003' and keyvalue='512000749' DELETE FROM base_bizColumnattach WHERE bizentityid='003003' and keyvalue='512000749' DELETE FROM base_bizattach WHERE bizentityid='003004' and keyvalue='512000749' DELETE FROM base_bizColumnattach WHERE bizentityid='003004' and keyvalue='512000749' DELETE FROM base_bizattach WHERE bizentityid='003005' and keyvalue='512000749' DELETE FROM base_bizColumnattach WHERE bizentityid='003005' and keyvalue='512000749' DELETE FROM base_bizattach WHERE bizentityid='006001' and keyvalue='512000749' DELETE FROM base_bizColumnattach WHERE bizentityid='006001' and keyvalue='512000749' DELETE FROM base_bizattach WHERE bizentityid='006002' and keyvalue='512000749' DELETE FROM base_bizColumnattach WHERE bizentityid='006002' and keyvalue='512000749' DELETE FROM base_bizattach WHERE bizentityid='006003' and keyvalue='512000749' DELETE FROM base_bizColumnattach WHERE bizentityid='006003' and keyvalue='512000749' DELETE FROM base_bizattach WHERE bizentityid='004003' and keyvalue='512000749' DELETE FROM base_bizColumnattach WHERE bizentityid='004003' and keyvalue='512000749' DELETE FROM base_bizattach WHERE bizentityid='004004' and keyvalue='512000749' DELETE FROM base_bizColumnattach WHERE bizentityid='004004' and keyvalue='512000749' DELETE FROM base_bizattach WHERE bizentityid='008002' and keyvalue='512000749' DELETE FROM base_bizColumnattach WHERE bizentityid='008002' and keyvalue='512000749' DELETE FROM base_bizattach WHERE bizentityid='003006' and keyvalue='512000749' DELETE FROM base_bizColumnattach WHERE bizentityid='003006' and keyvalue='512000749' DELETE FROM base_bizattach WHERE bizentityid='001035001' and keyvalue='512000749' DELETE FROM base_bizColumnattach WHERE bizentityid='001035001' and keyvalue='512000749' DELETE FROM base_bizattach WHERE bizentityid='003025' and keyvalue='512000749' DELETE FROM base_bizColumnattach WHERE bizentityid='003025' and keyvalue='512000749' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='003002' and rowid='512000749') DELETE FROM wf_workflowinstance where bizentityid='003002' and rowid='512000749' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='008001' and rowid='512000749') DELETE FROM wf_workflowinstance where bizentityid='008001' and rowid='512000749' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='003003' and rowid='512000749') DELETE FROM wf_workflowinstance where bizentityid='003003' and rowid='512000749' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='003004' and rowid='512000749') DELETE FROM wf_workflowinstance where bizentityid='003004' and rowid='512000749' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='003005' and rowid='512000749') DELETE FROM wf_workflowinstance where bizentityid='003005' and rowid='512000749' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='006001' and rowid='512000749') DELETE FROM wf_workflowinstance where bizentityid='006001' and rowid='512000749' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='006002' and rowid='512000749') DELETE FROM wf_workflowinstance where bizentityid='006002' and rowid='512000749' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='006003' and rowid='512000749') DELETE FROM wf_workflowinstance where bizentityid='006003' and rowid='512000749' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='004003' and rowid='512000749') DELETE FROM wf_workflowinstance where bizentityid='004003' and rowid='512000749' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='004004' and rowid='512000749') DELETE FROM wf_workflowinstance where bizentityid='004004' and rowid='512000749' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='008002' and rowid='512000749') DELETE FROM wf_workflowinstance where bizentityid='008002' and rowid='512000749' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='003006' and rowid='512000749') DELETE FROM wf_workflowinstance where bizentityid='003006' and rowid='512000749' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='001035001' and rowid='512000749') DELETE FROM wf_workflowinstance where bizentityid='001035001' and rowid='512000749' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='003025' and rowid='512000749') DELETE FROM wf_workflowinstance where bizentityid='003025' and rowid='512000749' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='003002' and rowid='512000749') DELETE FROM wf_bizflowinstance where bizentityid='003002' and rowid='512000749' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='008001' and rowid='512000749') DELETE FROM wf_bizflowinstance where bizentityid='008001' and rowid='512000749' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='003003' and rowid='512000749') DELETE FROM wf_bizflowinstance where bizentityid='003003' and rowid='512000749' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='003004' and rowid='512000749') DELETE FROM wf_bizflowinstance where bizentityid='003004' and rowid='512000749' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='003005' and rowid='512000749') DELETE FROM wf_bizflowinstance where bizentityid='003005' and rowid='512000749' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='006001' and rowid='512000749') DELETE FROM wf_bizflowinstance where bizentityid='006001' and rowid='512000749' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='006002' and rowid='512000749') DELETE FROM wf_bizflowinstance where bizentityid='006002' and rowid='512000749' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='006003' and rowid='512000749') DELETE FROM wf_bizflowinstance where bizentityid='006003' and rowid='512000749' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='004003' and rowid='512000749') DELETE FROM wf_bizflowinstance where bizentityid='004003' and rowid='512000749' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='004004' and rowid='512000749') DELETE FROM wf_bizflowinstance where bizentityid='004004' and rowid='512000749' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='008002' and rowid='512000749') DELETE FROM wf_bizflowinstance where bizentityid='008002' and rowid='512000749' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='003006' and rowid='512000749') DELETE FROM wf_bizflowinstance where bizentityid='003006' and rowid='512000749' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='001035001' and rowid='512000749') DELETE FROM wf_bizflowinstance where bizentityid='001035001' and rowid='512000749' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='003025' and rowid='512000749') DELETE FROM wf_bizflowinstance where bizentityid='003025' and rowid='512000749'

2025-12-08 17:13:29 执行时长：8.16秒 sql:DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCerti' and keyvalue in (select id from  GB_ProjectPlanCerti where ProjectNo = N'20984-2024-QE-E') delete from  GB_ProjectPlanCerti where ProjectNo = N'20984-2024-QE-E' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCerti' and keyvalue in (select id from  GB_ProjectPlanCerti where ProjectNo = N'20984-2024-QE-E') delete from  GB_ProjectPlanCerti where ProjectNo = N'20984-2024-QE-E' DELETE FROM base_bizColumnattach WHERE accesspath='GB_CertiDoc' and keyvalue in (select id from  GB_CertiDoc where ProjectNo = N'20984-2024-QE-E') delete from  GB_CertiDoc where ProjectNo = N'20984-2024-QE-E' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanEnergy' and keyvalue in (select id from  GB_ProjectPlanEnergy where PlanNo = N'20984-2024-QE-E-100') delete from  GB_ProjectPlanEnergy where PlanNo = N'20984-2024-QE-E-100' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from  GB_ProjectPlanTeam where TaskNo = N'702f425a031f45b1b234cadf8ea8bf07') delete from  GB_ProjectPlanTeam where TaskNo = N'702f425a031f45b1b234cadf8ea8bf07' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'702f425a031f45b1b234cadf8ea8bf07') delete from  GB_ProjectPlanCombine where TaskNo = N'702f425a031f45b1b234cadf8ea8bf07' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'702f425a031f45b1b234cadf8ea8bf07') delete from  GB_ProjectPlanCombine where TaskNo = N'702f425a031f45b1b234cadf8ea8bf07' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'702f425a031f45b1b234cadf8ea8bf07') delete from  GB_ProjectPlanCombine where TaskNo = N'702f425a031f45b1b234cadf8ea8bf07' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'702f425a031f45b1b234cadf8ea8bf07') delete from  GB_ProjectPlanCombine where TaskNo = N'702f425a031f45b1b234cadf8ea8bf07' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'702f425a031f45b1b234cadf8ea8bf07') delete from  GB_ProjectPlanCombine where TaskNo = N'702f425a031f45b1b234cadf8ea8bf07' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from  GB_ProjectPlanTeam where TaskNo = N'702f425a031f45b1b234cadf8ea8bf07') delete from  GB_ProjectPlanTeam where TaskNo = N'702f425a031f45b1b234cadf8ea8bf07' DELETE FROM base_bizColumnattach WHERE accesspath='GB_AuditProblem' and keyvalue in (select id from  GB_AuditProblem where TaskNo = N'702f425a031f45b1b234cadf8ea8bf07') delete from  GB_AuditProblem where TaskNo = N'702f425a031f45b1b234cadf8ea8bf07' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'702f425a031f45b1b234cadf8ea8bf07') delete from  GB_ProjectPlanCombine where TaskNo = N'702f425a031f45b1b234cadf8ea8bf07' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from  GB_ProjectPlanTeam where TaskNo = N'702f425a031f45b1b234cadf8ea8bf07') delete from  GB_ProjectPlanTeam where TaskNo = N'702f425a031f45b1b234cadf8ea8bf07' DELETE FROM base_bizColumnattach WHERE accesspath='GB_AuditProblem' and keyvalue in (select id from  GB_AuditProblem where TaskNo = N'702f425a031f45b1b234cadf8ea8bf07') delete from  GB_AuditProblem where TaskNo = N'702f425a031f45b1b234cadf8ea8bf07' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'702f425a031f45b1b234cadf8ea8bf07') delete from  GB_ProjectPlanCombine where TaskNo = N'702f425a031f45b1b234cadf8ea8bf07' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from  GB_ProjectPlanTeam where TaskNo = N'702f425a031f45b1b234cadf8ea8bf07') delete from  GB_ProjectPlanTeam where TaskNo = N'702f425a031f45b1b234cadf8ea8bf07' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'702f425a031f45b1b234cadf8ea8bf07') delete from  GB_ProjectPlanCombine where TaskNo = N'702f425a031f45b1b234cadf8ea8bf07' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'702f425a031f45b1b234cadf8ea8bf07') delete from  GB_ProjectPlanCombine where TaskNo = N'702f425a031f45b1b234cadf8ea8bf07' DELETE FROM base_bizColumnattach WHERE accesspath='GB_InvalidDoc' and keyvalue in (select id from  GB_InvalidDoc where TaskNo = N'702f425a031f45b1b234cadf8ea8bf07') delete from  GB_InvalidDoc where TaskNo = N'702f425a031f45b1b234cadf8ea8bf07' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from  GB_ProjectPlanTeam where TaskNo = N'702f425a031f45b1b234cadf8ea8bf07') delete from  GB_ProjectPlanTeam where TaskNo = N'702f425a031f45b1b234cadf8ea8bf07' DELETE FROM base_bizColumnattach WHERE accesspath='GB_AuditorContactRecord' and keyvalue in (select id from  GB_AuditorContactRecord where TaskNo = N'702f425a031f45b1b234cadf8ea8bf07') delete from  GB_AuditorContactRecord where TaskNo = N'702f425a031f45b1b234cadf8ea8bf07' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'702f425a031f45b1b234cadf8ea8bf07') delete from  GB_ProjectPlanCombine where TaskNo = N'702f425a031f45b1b234cadf8ea8bf07' DELETE FROM base_bizColumnattach WHERE accesspath='GB_AuditProblem' and keyvalue in (select id from  GB_AuditProblem where TaskNo = N'702f425a031f45b1b234cadf8ea8bf07') delete from  GB_AuditProblem where TaskNo = N'702f425a031f45b1b234cadf8ea8bf07' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from  GB_ProjectPlanTeam where TaskNo = N'702f425a031f45b1b234cadf8ea8bf07') delete from  GB_ProjectPlanTeam where TaskNo = N'702f425a031f45b1b234cadf8ea8bf07' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'702f425a031f45b1b234cadf8ea8bf07') delete from  GB_ProjectPlanCombine where TaskNo = N'702f425a031f45b1b234cadf8ea8bf07' DELETE FROM base_bizColumnattach WHERE accesspath='GB_AuditorContactRecord' and keyvalue in (select id from  GB_AuditorContactRecord where TaskNo = N'702f425a031f45b1b234cadf8ea8bf07') delete from  GB_AuditorContactRecord where TaskNo = N'702f425a031f45b1b234cadf8ea8bf07' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'702f425a031f45b1b234cadf8ea8bf07') delete from  GB_ProjectPlanCombine where TaskNo = N'702f425a031f45b1b234cadf8ea8bf07' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from  GB_ProjectPlanTeam where TaskNo = N'702f425a031f45b1b234cadf8ea8bf07') delete from  GB_ProjectPlanTeam where TaskNo = N'702f425a031f45b1b234cadf8ea8bf07' DELETE FROM GB_ProjectPlan WHERE ID='512000759' DELETE FROM base_bizattach WHERE bizentityid='003002' and keyvalue='512000759' DELETE FROM base_bizColumnattach WHERE bizentityid='003002' and keyvalue='512000759' DELETE FROM base_bizattach WHERE bizentityid='008001' and keyvalue='512000759' DELETE FROM base_bizColumnattach WHERE bizentityid='008001' and keyvalue='512000759' DELETE FROM base_bizattach WHERE bizentityid='003003' and keyvalue='512000759' DELETE FROM base_bizColumnattach WHERE bizentityid='003003' and keyvalue='512000759' DELETE FROM base_bizattach WHERE bizentityid='003004' and keyvalue='512000759' DELETE FROM base_bizColumnattach WHERE bizentityid='003004' and keyvalue='512000759' DELETE FROM base_bizattach WHERE bizentityid='003005' and keyvalue='512000759' DELETE FROM base_bizColumnattach WHERE bizentityid='003005' and keyvalue='512000759' DELETE FROM base_bizattach WHERE bizentityid='006001' and keyvalue='512000759' DELETE FROM base_bizColumnattach WHERE bizentityid='006001' and keyvalue='512000759' DELETE FROM base_bizattach WHERE bizentityid='006002' and keyvalue='512000759' DELETE FROM base_bizColumnattach WHERE bizentityid='006002' and keyvalue='512000759' DELETE FROM base_bizattach WHERE bizentityid='006003' and keyvalue='512000759' DELETE FROM base_bizColumnattach WHERE bizentityid='006003' and keyvalue='512000759' DELETE FROM base_bizattach WHERE bizentityid='004003' and keyvalue='512000759' DELETE FROM base_bizColumnattach WHERE bizentityid='004003' and keyvalue='512000759' DELETE FROM base_bizattach WHERE bizentityid='004004' and keyvalue='512000759' DELETE FROM base_bizColumnattach WHERE bizentityid='004004' and keyvalue='512000759' DELETE FROM base_bizattach WHERE bizentityid='008002' and keyvalue='512000759' DELETE FROM base_bizColumnattach WHERE bizentityid='008002' and keyvalue='512000759' DELETE FROM base_bizattach WHERE bizentityid='003006' and keyvalue='512000759' DELETE FROM base_bizColumnattach WHERE bizentityid='003006' and keyvalue='512000759' DELETE FROM base_bizattach WHERE bizentityid='001035001' and keyvalue='512000759' DELETE FROM base_bizColumnattach WHERE bizentityid='001035001' and keyvalue='512000759' DELETE FROM base_bizattach WHERE bizentityid='003025' and keyvalue='512000759' DELETE FROM base_bizColumnattach WHERE bizentityid='003025' and keyvalue='512000759' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='003002' and rowid='512000759') DELETE FROM wf_workflowinstance where bizentityid='003002' and rowid='512000759' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='008001' and rowid='512000759') DELETE FROM wf_workflowinstance where bizentityid='008001' and rowid='512000759' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='003003' and rowid='512000759') DELETE FROM wf_workflowinstance where bizentityid='003003' and rowid='512000759' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='003004' and rowid='512000759') DELETE FROM wf_workflowinstance where bizentityid='003004' and rowid='512000759' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='003005' and rowid='512000759') DELETE FROM wf_workflowinstance where bizentityid='003005' and rowid='512000759' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='006001' and rowid='512000759') DELETE FROM wf_workflowinstance where bizentityid='006001' and rowid='512000759' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='006002' and rowid='512000759') DELETE FROM wf_workflowinstance where bizentityid='006002' and rowid='512000759' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='006003' and rowid='512000759') DELETE FROM wf_workflowinstance where bizentityid='006003' and rowid='512000759' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='004003' and rowid='512000759') DELETE FROM wf_workflowinstance where bizentityid='004003' and rowid='512000759' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='004004' and rowid='512000759') DELETE FROM wf_workflowinstance where bizentityid='004004' and rowid='512000759' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='008002' and rowid='512000759') DELETE FROM wf_workflowinstance where bizentityid='008002' and rowid='512000759' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='003006' and rowid='512000759') DELETE FROM wf_workflowinstance where bizentityid='003006' and rowid='512000759' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='001035001' and rowid='512000759') DELETE FROM wf_workflowinstance where bizentityid='001035001' and rowid='512000759' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='003025' and rowid='512000759') DELETE FROM wf_workflowinstance where bizentityid='003025' and rowid='512000759' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='003002' and rowid='512000759') DELETE FROM wf_bizflowinstance where bizentityid='003002' and rowid='512000759' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='008001' and rowid='512000759') DELETE FROM wf_bizflowinstance where bizentityid='008001' and rowid='512000759' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='003003' and rowid='512000759') DELETE FROM wf_bizflowinstance where bizentityid='003003' and rowid='512000759' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='003004' and rowid='512000759') DELETE FROM wf_bizflowinstance where bizentityid='003004' and rowid='512000759' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='003005' and rowid='512000759') DELETE FROM wf_bizflowinstance where bizentityid='003005' and rowid='512000759' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='006001' and rowid='512000759') DELETE FROM wf_bizflowinstance where bizentityid='006001' and rowid='512000759' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='006002' and rowid='512000759') DELETE FROM wf_bizflowinstance where bizentityid='006002' and rowid='512000759' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='006003' and rowid='512000759') DELETE FROM wf_bizflowinstance where bizentityid='006003' and rowid='512000759' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='004003' and rowid='512000759') DELETE FROM wf_bizflowinstance where bizentityid='004003' and rowid='512000759' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='004004' and rowid='512000759') DELETE FROM wf_bizflowinstance where bizentityid='004004' and rowid='512000759' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='008002' and rowid='512000759') DELETE FROM wf_bizflowinstance where bizentityid='008002' and rowid='512000759' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='003006' and rowid='512000759') DELETE FROM wf_bizflowinstance where bizentityid='003006' and rowid='512000759' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='001035001' and rowid='512000759') DELETE FROM wf_bizflowinstance where bizentityid='001035001' and rowid='512000759' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='003025' and rowid='512000759') DELETE FROM wf_bizflowinstance where bizentityid='003025' and rowid='512000759'

2025-12-08 17:13:38 执行时长：8.44秒 sql:DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCerti' and keyvalue in (select id from  GB_ProjectPlanCerti where ProjectNo = N'20984-2024-QE-Q') delete from  GB_ProjectPlanCerti where ProjectNo = N'20984-2024-QE-Q' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCerti' and keyvalue in (select id from  GB_ProjectPlanCerti where ProjectNo = N'20984-2024-QE-Q') delete from  GB_ProjectPlanCerti where ProjectNo = N'20984-2024-QE-Q' DELETE FROM base_bizColumnattach WHERE accesspath='GB_CertiDoc' and keyvalue in (select id from  GB_CertiDoc where ProjectNo = N'20984-2024-QE-Q') delete from  GB_CertiDoc where ProjectNo = N'20984-2024-QE-Q' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanEnergy' and keyvalue in (select id from  GB_ProjectPlanEnergy where PlanNo = N'20984-2024-QE-Q-100') delete from  GB_ProjectPlanEnergy where PlanNo = N'20984-2024-QE-Q-100' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from  GB_ProjectPlanTeam where TaskNo = N'702f425a031f45b1b234cadf8ea8bf07') delete from  GB_ProjectPlanTeam where TaskNo = N'702f425a031f45b1b234cadf8ea8bf07' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'702f425a031f45b1b234cadf8ea8bf07') delete from  GB_ProjectPlanCombine where TaskNo = N'702f425a031f45b1b234cadf8ea8bf07' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'702f425a031f45b1b234cadf8ea8bf07') delete from  GB_ProjectPlanCombine where TaskNo = N'702f425a031f45b1b234cadf8ea8bf07' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'702f425a031f45b1b234cadf8ea8bf07') delete from  GB_ProjectPlanCombine where TaskNo = N'702f425a031f45b1b234cadf8ea8bf07' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'702f425a031f45b1b234cadf8ea8bf07') delete from  GB_ProjectPlanCombine where TaskNo = N'702f425a031f45b1b234cadf8ea8bf07' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'702f425a031f45b1b234cadf8ea8bf07') delete from  GB_ProjectPlanCombine where TaskNo = N'702f425a031f45b1b234cadf8ea8bf07' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from  GB_ProjectPlanTeam where TaskNo = N'702f425a031f45b1b234cadf8ea8bf07') delete from  GB_ProjectPlanTeam where TaskNo = N'702f425a031f45b1b234cadf8ea8bf07' DELETE FROM base_bizColumnattach WHERE accesspath='GB_AuditProblem' and keyvalue in (select id from  GB_AuditProblem where TaskNo = N'702f425a031f45b1b234cadf8ea8bf07') delete from  GB_AuditProblem where TaskNo = N'702f425a031f45b1b234cadf8ea8bf07' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'702f425a031f45b1b234cadf8ea8bf07') delete from  GB_ProjectPlanCombine where TaskNo = N'702f425a031f45b1b234cadf8ea8bf07' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from  GB_ProjectPlanTeam where TaskNo = N'702f425a031f45b1b234cadf8ea8bf07') delete from  GB_ProjectPlanTeam where TaskNo = N'702f425a031f45b1b234cadf8ea8bf07' DELETE FROM base_bizColumnattach WHERE accesspath='GB_AuditProblem' and keyvalue in (select id from  GB_AuditProblem where TaskNo = N'702f425a031f45b1b234cadf8ea8bf07') delete from  GB_AuditProblem where TaskNo = N'702f425a031f45b1b234cadf8ea8bf07' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'702f425a031f45b1b234cadf8ea8bf07') delete from  GB_ProjectPlanCombine where TaskNo = N'702f425a031f45b1b234cadf8ea8bf07' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from  GB_ProjectPlanTeam where TaskNo = N'702f425a031f45b1b234cadf8ea8bf07') delete from  GB_ProjectPlanTeam where TaskNo = N'702f425a031f45b1b234cadf8ea8bf07' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'702f425a031f45b1b234cadf8ea8bf07') delete from  GB_ProjectPlanCombine where TaskNo = N'702f425a031f45b1b234cadf8ea8bf07' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'702f425a031f45b1b234cadf8ea8bf07') delete from  GB_ProjectPlanCombine where TaskNo = N'702f425a031f45b1b234cadf8ea8bf07' DELETE FROM base_bizColumnattach WHERE accesspath='GB_InvalidDoc' and keyvalue in (select id from  GB_InvalidDoc where TaskNo = N'702f425a031f45b1b234cadf8ea8bf07') delete from  GB_InvalidDoc where TaskNo = N'702f425a031f45b1b234cadf8ea8bf07' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from  GB_ProjectPlanTeam where TaskNo = N'702f425a031f45b1b234cadf8ea8bf07') delete from  GB_ProjectPlanTeam where TaskNo = N'702f425a031f45b1b234cadf8ea8bf07' DELETE FROM base_bizColumnattach WHERE accesspath='GB_AuditorContactRecord' and keyvalue in (select id from  GB_AuditorContactRecord where TaskNo = N'702f425a031f45b1b234cadf8ea8bf07') delete from  GB_AuditorContactRecord where TaskNo = N'702f425a031f45b1b234cadf8ea8bf07' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'702f425a031f45b1b234cadf8ea8bf07') delete from  GB_ProjectPlanCombine where TaskNo = N'702f425a031f45b1b234cadf8ea8bf07' DELETE FROM base_bizColumnattach WHERE accesspath='GB_AuditProblem' and keyvalue in (select id from  GB_AuditProblem where TaskNo = N'702f425a031f45b1b234cadf8ea8bf07') delete from  GB_AuditProblem where TaskNo = N'702f425a031f45b1b234cadf8ea8bf07' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from  GB_ProjectPlanTeam where TaskNo = N'702f425a031f45b1b234cadf8ea8bf07') delete from  GB_ProjectPlanTeam where TaskNo = N'702f425a031f45b1b234cadf8ea8bf07' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'702f425a031f45b1b234cadf8ea8bf07') delete from  GB_ProjectPlanCombine where TaskNo = N'702f425a031f45b1b234cadf8ea8bf07' DELETE FROM base_bizColumnattach WHERE accesspath='GB_AuditorContactRecord' and keyvalue in (select id from  GB_AuditorContactRecord where TaskNo = N'702f425a031f45b1b234cadf8ea8bf07') delete from  GB_AuditorContactRecord where TaskNo = N'702f425a031f45b1b234cadf8ea8bf07' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'702f425a031f45b1b234cadf8ea8bf07') delete from  GB_ProjectPlanCombine where TaskNo = N'702f425a031f45b1b234cadf8ea8bf07' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from  GB_ProjectPlanTeam where TaskNo = N'702f425a031f45b1b234cadf8ea8bf07') delete from  GB_ProjectPlanTeam where TaskNo = N'702f425a031f45b1b234cadf8ea8bf07' DELETE FROM GB_ProjectPlan WHERE ID='512000761' DELETE FROM base_bizattach WHERE bizentityid='003002' and keyvalue='512000761' DELETE FROM base_bizColumnattach WHERE bizentityid='003002' and keyvalue='512000761' DELETE FROM base_bizattach WHERE bizentityid='008001' and keyvalue='512000761' DELETE FROM base_bizColumnattach WHERE bizentityid='008001' and keyvalue='512000761' DELETE FROM base_bizattach WHERE bizentityid='003003' and keyvalue='512000761' DELETE FROM base_bizColumnattach WHERE bizentityid='003003' and keyvalue='512000761' DELETE FROM base_bizattach WHERE bizentityid='003004' and keyvalue='512000761' DELETE FROM base_bizColumnattach WHERE bizentityid='003004' and keyvalue='512000761' DELETE FROM base_bizattach WHERE bizentityid='003005' and keyvalue='512000761' DELETE FROM base_bizColumnattach WHERE bizentityid='003005' and keyvalue='512000761' DELETE FROM base_bizattach WHERE bizentityid='006001' and keyvalue='512000761' DELETE FROM base_bizColumnattach WHERE bizentityid='006001' and keyvalue='512000761' DELETE FROM base_bizattach WHERE bizentityid='006002' and keyvalue='512000761' DELETE FROM base_bizColumnattach WHERE bizentityid='006002' and keyvalue='512000761' DELETE FROM base_bizattach WHERE bizentityid='006003' and keyvalue='512000761' DELETE FROM base_bizColumnattach WHERE bizentityid='006003' and keyvalue='512000761' DELETE FROM base_bizattach WHERE bizentityid='004003' and keyvalue='512000761' DELETE FROM base_bizColumnattach WHERE bizentityid='004003' and keyvalue='512000761' DELETE FROM base_bizattach WHERE bizentityid='004004' and keyvalue='512000761' DELETE FROM base_bizColumnattach WHERE bizentityid='004004' and keyvalue='512000761' DELETE FROM base_bizattach WHERE bizentityid='008002' and keyvalue='512000761' DELETE FROM base_bizColumnattach WHERE bizentityid='008002' and keyvalue='512000761' DELETE FROM base_bizattach WHERE bizentityid='003006' and keyvalue='512000761' DELETE FROM base_bizColumnattach WHERE bizentityid='003006' and keyvalue='512000761' DELETE FROM base_bizattach WHERE bizentityid='001035001' and keyvalue='512000761' DELETE FROM base_bizColumnattach WHERE bizentityid='001035001' and keyvalue='512000761' DELETE FROM base_bizattach WHERE bizentityid='003025' and keyvalue='512000761' DELETE FROM base_bizColumnattach WHERE bizentityid='003025' and keyvalue='512000761' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='003002' and rowid='512000761') DELETE FROM wf_workflowinstance where bizentityid='003002' and rowid='512000761' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='008001' and rowid='512000761') DELETE FROM wf_workflowinstance where bizentityid='008001' and rowid='512000761' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='003003' and rowid='512000761') DELETE FROM wf_workflowinstance where bizentityid='003003' and rowid='512000761' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='003004' and rowid='512000761') DELETE FROM wf_workflowinstance where bizentityid='003004' and rowid='512000761' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='003005' and rowid='512000761') DELETE FROM wf_workflowinstance where bizentityid='003005' and rowid='512000761' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='006001' and rowid='512000761') DELETE FROM wf_workflowinstance where bizentityid='006001' and rowid='512000761' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='006002' and rowid='512000761') DELETE FROM wf_workflowinstance where bizentityid='006002' and rowid='512000761' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='006003' and rowid='512000761') DELETE FROM wf_workflowinstance where bizentityid='006003' and rowid='512000761' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='004003' and rowid='512000761') DELETE FROM wf_workflowinstance where bizentityid='004003' and rowid='512000761' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='004004' and rowid='512000761') DELETE FROM wf_workflowinstance where bizentityid='004004' and rowid='512000761' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='008002' and rowid='512000761') DELETE FROM wf_workflowinstance where bizentityid='008002' and rowid='512000761' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='003006' and rowid='512000761') DELETE FROM wf_workflowinstance where bizentityid='003006' and rowid='512000761' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='001035001' and rowid='512000761') DELETE FROM wf_workflowinstance where bizentityid='001035001' and rowid='512000761' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='003025' and rowid='512000761') DELETE FROM wf_workflowinstance where bizentityid='003025' and rowid='512000761' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='003002' and rowid='512000761') DELETE FROM wf_bizflowinstance where bizentityid='003002' and rowid='512000761' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='008001' and rowid='512000761') DELETE FROM wf_bizflowinstance where bizentityid='008001' and rowid='512000761' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='003003' and rowid='512000761') DELETE FROM wf_bizflowinstance where bizentityid='003003' and rowid='512000761' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='003004' and rowid='512000761') DELETE FROM wf_bizflowinstance where bizentityid='003004' and rowid='512000761' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='003005' and rowid='512000761') DELETE FROM wf_bizflowinstance where bizentityid='003005' and rowid='512000761' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='006001' and rowid='512000761') DELETE FROM wf_bizflowinstance where bizentityid='006001' and rowid='512000761' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='006002' and rowid='512000761') DELETE FROM wf_bizflowinstance where bizentityid='006002' and rowid='512000761' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='006003' and rowid='512000761') DELETE FROM wf_bizflowinstance where bizentityid='006003' and rowid='512000761' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='004003' and rowid='512000761') DELETE FROM wf_bizflowinstance where bizentityid='004003' and rowid='512000761' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='004004' and rowid='512000761') DELETE FROM wf_bizflowinstance where bizentityid='004004' and rowid='512000761' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='008002' and rowid='512000761') DELETE FROM wf_bizflowinstance where bizentityid='008002' and rowid='512000761' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='003006' and rowid='512000761') DELETE FROM wf_bizflowinstance where bizentityid='003006' and rowid='512000761' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='001035001' and rowid='512000761') DELETE FROM wf_bizflowinstance where bizentityid='001035001' and rowid='512000761' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='003025' and rowid='512000761') DELETE FROM wf_bizflowinstance where bizentityid='003025' and rowid='512000761'

2025-12-08 17:13:46 执行时长：7.81秒 sql:DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCerti' and keyvalue in (select id from  GB_ProjectPlanCerti where ProjectNo = N'20984-2024-QE-E') delete from  GB_ProjectPlanCerti where ProjectNo = N'20984-2024-QE-E' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCerti' and keyvalue in (select id from  GB_ProjectPlanCerti where ProjectNo = N'20984-2024-QE-E') delete from  GB_ProjectPlanCerti where ProjectNo = N'20984-2024-QE-E' DELETE FROM base_bizColumnattach WHERE accesspath='GB_CertiDoc' and keyvalue in (select id from  GB_CertiDoc where ProjectNo = N'20984-2024-QE-E') delete from  GB_CertiDoc where ProjectNo = N'20984-2024-QE-E' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanEnergy' and keyvalue in (select id from  GB_ProjectPlanEnergy where PlanNo = N'20984-2024-QE-E-200') delete from  GB_ProjectPlanEnergy where PlanNo = N'20984-2024-QE-E-200' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from  GB_ProjectPlanTeam where TaskNo = N'b1ac73c5ecd441aa8989b808b8580b4d') delete from  GB_ProjectPlanTeam where TaskNo = N'b1ac73c5ecd441aa8989b808b8580b4d' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'b1ac73c5ecd441aa8989b808b8580b4d') delete from  GB_ProjectPlanCombine where TaskNo = N'b1ac73c5ecd441aa8989b808b8580b4d' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'b1ac73c5ecd441aa8989b808b8580b4d') delete from  GB_ProjectPlanCombine where TaskNo = N'b1ac73c5ecd441aa8989b808b8580b4d' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'b1ac73c5ecd441aa8989b808b8580b4d') delete from  GB_ProjectPlanCombine where TaskNo = N'b1ac73c5ecd441aa8989b808b8580b4d' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'b1ac73c5ecd441aa8989b808b8580b4d') delete from  GB_ProjectPlanCombine where TaskNo = N'b1ac73c5ecd441aa8989b808b8580b4d' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'b1ac73c5ecd441aa8989b808b8580b4d') delete from  GB_ProjectPlanCombine where TaskNo = N'b1ac73c5ecd441aa8989b808b8580b4d' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from  GB_ProjectPlanTeam where TaskNo = N'b1ac73c5ecd441aa8989b808b8580b4d') delete from  GB_ProjectPlanTeam where TaskNo = N'b1ac73c5ecd441aa8989b808b8580b4d' DELETE FROM base_bizColumnattach WHERE accesspath='GB_AuditProblem' and keyvalue in (select id from  GB_AuditProblem where TaskNo = N'b1ac73c5ecd441aa8989b808b8580b4d') delete from  GB_AuditProblem where TaskNo = N'b1ac73c5ecd441aa8989b808b8580b4d' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'b1ac73c5ecd441aa8989b808b8580b4d') delete from  GB_ProjectPlanCombine where TaskNo = N'b1ac73c5ecd441aa8989b808b8580b4d' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from  GB_ProjectPlanTeam where TaskNo = N'b1ac73c5ecd441aa8989b808b8580b4d') delete from  GB_ProjectPlanTeam where TaskNo = N'b1ac73c5ecd441aa8989b808b8580b4d' DELETE FROM base_bizColumnattach WHERE accesspath='GB_AuditProblem' and keyvalue in (select id from  GB_AuditProblem where TaskNo = N'b1ac73c5ecd441aa8989b808b8580b4d') delete from  GB_AuditProblem where TaskNo = N'b1ac73c5ecd441aa8989b808b8580b4d' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'b1ac73c5ecd441aa8989b808b8580b4d') delete from  GB_ProjectPlanCombine where TaskNo = N'b1ac73c5ecd441aa8989b808b8580b4d' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from  GB_ProjectPlanTeam where TaskNo = N'b1ac73c5ecd441aa8989b808b8580b4d') delete from  GB_ProjectPlanTeam where TaskNo = N'b1ac73c5ecd441aa8989b808b8580b4d' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'b1ac73c5ecd441aa8989b808b8580b4d') delete from  GB_ProjectPlanCombine where TaskNo = N'b1ac73c5ecd441aa8989b808b8580b4d' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'b1ac73c5ecd441aa8989b808b8580b4d') delete from  GB_ProjectPlanCombine where TaskNo = N'b1ac73c5ecd441aa8989b808b8580b4d' DELETE FROM base_bizColumnattach WHERE accesspath='GB_InvalidDoc' and keyvalue in (select id from  GB_InvalidDoc where TaskNo = N'b1ac73c5ecd441aa8989b808b8580b4d') delete from  GB_InvalidDoc where TaskNo = N'b1ac73c5ecd441aa8989b808b8580b4d' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from  GB_ProjectPlanTeam where TaskNo = N'b1ac73c5ecd441aa8989b808b8580b4d') delete from  GB_ProjectPlanTeam where TaskNo = N'b1ac73c5ecd441aa8989b808b8580b4d' DELETE FROM base_bizColumnattach WHERE accesspath='GB_AuditorContactRecord' and keyvalue in (select id from  GB_AuditorContactRecord where TaskNo = N'b1ac73c5ecd441aa8989b808b8580b4d') delete from  GB_AuditorContactRecord where TaskNo = N'b1ac73c5ecd441aa8989b808b8580b4d' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'b1ac73c5ecd441aa8989b808b8580b4d') delete from  GB_ProjectPlanCombine where TaskNo = N'b1ac73c5ecd441aa8989b808b8580b4d' DELETE FROM base_bizColumnattach WHERE accesspath='GB_AuditProblem' and keyvalue in (select id from  GB_AuditProblem where TaskNo = N'b1ac73c5ecd441aa8989b808b8580b4d') delete from  GB_AuditProblem where TaskNo = N'b1ac73c5ecd441aa8989b808b8580b4d' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from  GB_ProjectPlanTeam where TaskNo = N'b1ac73c5ecd441aa8989b808b8580b4d') delete from  GB_ProjectPlanTeam where TaskNo = N'b1ac73c5ecd441aa8989b808b8580b4d' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'b1ac73c5ecd441aa8989b808b8580b4d') delete from  GB_ProjectPlanCombine where TaskNo = N'b1ac73c5ecd441aa8989b808b8580b4d' DELETE FROM base_bizColumnattach WHERE accesspath='GB_AuditorContactRecord' and keyvalue in (select id from  GB_AuditorContactRecord where TaskNo = N'b1ac73c5ecd441aa8989b808b8580b4d') delete from  GB_AuditorContactRecord where TaskNo = N'b1ac73c5ecd441aa8989b808b8580b4d' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'b1ac73c5ecd441aa8989b808b8580b4d') delete from  GB_ProjectPlanCombine where TaskNo = N'b1ac73c5ecd441aa8989b808b8580b4d' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from  GB_ProjectPlanTeam where TaskNo = N'b1ac73c5ecd441aa8989b808b8580b4d') delete from  GB_ProjectPlanTeam where TaskNo = N'b1ac73c5ecd441aa8989b808b8580b4d' DELETE FROM GB_ProjectPlan WHERE ID='512000758' DELETE FROM base_bizattach WHERE bizentityid='003002' and keyvalue='512000758' DELETE FROM base_bizColumnattach WHERE bizentityid='003002' and keyvalue='512000758' DELETE FROM base_bizattach WHERE bizentityid='008001' and keyvalue='512000758' DELETE FROM base_bizColumnattach WHERE bizentityid='008001' and keyvalue='512000758' DELETE FROM base_bizattach WHERE bizentityid='003003' and keyvalue='512000758' DELETE FROM base_bizColumnattach WHERE bizentityid='003003' and keyvalue='512000758' DELETE FROM base_bizattach WHERE bizentityid='003004' and keyvalue='512000758' DELETE FROM base_bizColumnattach WHERE bizentityid='003004' and keyvalue='512000758' DELETE FROM base_bizattach WHERE bizentityid='003005' and keyvalue='512000758' DELETE FROM base_bizColumnattach WHERE bizentityid='003005' and keyvalue='512000758' DELETE FROM base_bizattach WHERE bizentityid='006001' and keyvalue='512000758' DELETE FROM base_bizColumnattach WHERE bizentityid='006001' and keyvalue='512000758' DELETE FROM base_bizattach WHERE bizentityid='006002' and keyvalue='512000758' DELETE FROM base_bizColumnattach WHERE bizentityid='006002' and keyvalue='512000758' DELETE FROM base_bizattach WHERE bizentityid='006003' and keyvalue='512000758' DELETE FROM base_bizColumnattach WHERE bizentityid='006003' and keyvalue='512000758' DELETE FROM base_bizattach WHERE bizentityid='004003' and keyvalue='512000758' DELETE FROM base_bizColumnattach WHERE bizentityid='004003' and keyvalue='512000758' DELETE FROM base_bizattach WHERE bizentityid='004004' and keyvalue='512000758' DELETE FROM base_bizColumnattach WHERE bizentityid='004004' and keyvalue='512000758' DELETE FROM base_bizattach WHERE bizentityid='008002' and keyvalue='512000758' DELETE FROM base_bizColumnattach WHERE bizentityid='008002' and keyvalue='512000758' DELETE FROM base_bizattach WHERE bizentityid='003006' and keyvalue='512000758' DELETE FROM base_bizColumnattach WHERE bizentityid='003006' and keyvalue='512000758' DELETE FROM base_bizattach WHERE bizentityid='001035001' and keyvalue='512000758' DELETE FROM base_bizColumnattach WHERE bizentityid='001035001' and keyvalue='512000758' DELETE FROM base_bizattach WHERE bizentityid='003025' and keyvalue='512000758' DELETE FROM base_bizColumnattach WHERE bizentityid='003025' and keyvalue='512000758' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='003002' and rowid='512000758') DELETE FROM wf_workflowinstance where bizentityid='003002' and rowid='512000758' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='008001' and rowid='512000758') DELETE FROM wf_workflowinstance where bizentityid='008001' and rowid='512000758' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='003003' and rowid='512000758') DELETE FROM wf_workflowinstance where bizentityid='003003' and rowid='512000758' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='003004' and rowid='512000758') DELETE FROM wf_workflowinstance where bizentityid='003004' and rowid='512000758' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='003005' and rowid='512000758') DELETE FROM wf_workflowinstance where bizentityid='003005' and rowid='512000758' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='006001' and rowid='512000758') DELETE FROM wf_workflowinstance where bizentityid='006001' and rowid='512000758' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='006002' and rowid='512000758') DELETE FROM wf_workflowinstance where bizentityid='006002' and rowid='512000758' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='006003' and rowid='512000758') DELETE FROM wf_workflowinstance where bizentityid='006003' and rowid='512000758' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='004003' and rowid='512000758') DELETE FROM wf_workflowinstance where bizentityid='004003' and rowid='512000758' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='004004' and rowid='512000758') DELETE FROM wf_workflowinstance where bizentityid='004004' and rowid='512000758' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='008002' and rowid='512000758') DELETE FROM wf_workflowinstance where bizentityid='008002' and rowid='512000758' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='003006' and rowid='512000758') DELETE FROM wf_workflowinstance where bizentityid='003006' and rowid='512000758' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='001035001' and rowid='512000758') DELETE FROM wf_workflowinstance where bizentityid='001035001' and rowid='512000758' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='003025' and rowid='512000758') DELETE FROM wf_workflowinstance where bizentityid='003025' and rowid='512000758' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='003002' and rowid='512000758') DELETE FROM wf_bizflowinstance where bizentityid='003002' and rowid='512000758' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='008001' and rowid='512000758') DELETE FROM wf_bizflowinstance where bizentityid='008001' and rowid='512000758' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='003003' and rowid='512000758') DELETE FROM wf_bizflowinstance where bizentityid='003003' and rowid='512000758' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='003004' and rowid='512000758') DELETE FROM wf_bizflowinstance where bizentityid='003004' and rowid='512000758' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='003005' and rowid='512000758') DELETE FROM wf_bizflowinstance where bizentityid='003005' and rowid='512000758' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='006001' and rowid='512000758') DELETE FROM wf_bizflowinstance where bizentityid='006001' and rowid='512000758' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='006002' and rowid='512000758') DELETE FROM wf_bizflowinstance where bizentityid='006002' and rowid='512000758' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='006003' and rowid='512000758') DELETE FROM wf_bizflowinstance where bizentityid='006003' and rowid='512000758' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='004003' and rowid='512000758') DELETE FROM wf_bizflowinstance where bizentityid='004003' and rowid='512000758' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='004004' and rowid='512000758') DELETE FROM wf_bizflowinstance where bizentityid='004004' and rowid='512000758' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='008002' and rowid='512000758') DELETE FROM wf_bizflowinstance where bizentityid='008002' and rowid='512000758' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='003006' and rowid='512000758') DELETE FROM wf_bizflowinstance where bizentityid='003006' and rowid='512000758' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='001035001' and rowid='512000758') DELETE FROM wf_bizflowinstance where bizentityid='001035001' and rowid='512000758' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='003025' and rowid='512000758') DELETE FROM wf_bizflowinstance where bizentityid='003025' and rowid='512000758'

2025-12-08 17:13:54 执行时长：7.84秒 sql:DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCerti' and keyvalue in (select id from  GB_ProjectPlanCerti where ProjectNo = N'20984-2024-QE-Q') delete from  GB_ProjectPlanCerti where ProjectNo = N'20984-2024-QE-Q' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCerti' and keyvalue in (select id from  GB_ProjectPlanCerti where ProjectNo = N'20984-2024-QE-Q') delete from  GB_ProjectPlanCerti where ProjectNo = N'20984-2024-QE-Q' DELETE FROM base_bizColumnattach WHERE accesspath='GB_CertiDoc' and keyvalue in (select id from  GB_CertiDoc where ProjectNo = N'20984-2024-QE-Q') delete from  GB_CertiDoc where ProjectNo = N'20984-2024-QE-Q' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanEnergy' and keyvalue in (select id from  GB_ProjectPlanEnergy where PlanNo = N'20984-2024-QE-Q-200') delete from  GB_ProjectPlanEnergy where PlanNo = N'20984-2024-QE-Q-200' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from  GB_ProjectPlanTeam where TaskNo = N'b1ac73c5ecd441aa8989b808b8580b4d') delete from  GB_ProjectPlanTeam where TaskNo = N'b1ac73c5ecd441aa8989b808b8580b4d' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'b1ac73c5ecd441aa8989b808b8580b4d') delete from  GB_ProjectPlanCombine where TaskNo = N'b1ac73c5ecd441aa8989b808b8580b4d' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'b1ac73c5ecd441aa8989b808b8580b4d') delete from  GB_ProjectPlanCombine where TaskNo = N'b1ac73c5ecd441aa8989b808b8580b4d' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'b1ac73c5ecd441aa8989b808b8580b4d') delete from  GB_ProjectPlanCombine where TaskNo = N'b1ac73c5ecd441aa8989b808b8580b4d' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'b1ac73c5ecd441aa8989b808b8580b4d') delete from  GB_ProjectPlanCombine where TaskNo = N'b1ac73c5ecd441aa8989b808b8580b4d' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'b1ac73c5ecd441aa8989b808b8580b4d') delete from  GB_ProjectPlanCombine where TaskNo = N'b1ac73c5ecd441aa8989b808b8580b4d' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from  GB_ProjectPlanTeam where TaskNo = N'b1ac73c5ecd441aa8989b808b8580b4d') delete from  GB_ProjectPlanTeam where TaskNo = N'b1ac73c5ecd441aa8989b808b8580b4d' DELETE FROM base_bizColumnattach WHERE accesspath='GB_AuditProblem' and keyvalue in (select id from  GB_AuditProblem where TaskNo = N'b1ac73c5ecd441aa8989b808b8580b4d') delete from  GB_AuditProblem where TaskNo = N'b1ac73c5ecd441aa8989b808b8580b4d' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'b1ac73c5ecd441aa8989b808b8580b4d') delete from  GB_ProjectPlanCombine where TaskNo = N'b1ac73c5ecd441aa8989b808b8580b4d' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from  GB_ProjectPlanTeam where TaskNo = N'b1ac73c5ecd441aa8989b808b8580b4d') delete from  GB_ProjectPlanTeam where TaskNo = N'b1ac73c5ecd441aa8989b808b8580b4d' DELETE FROM base_bizColumnattach WHERE accesspath='GB_AuditProblem' and keyvalue in (select id from  GB_AuditProblem where TaskNo = N'b1ac73c5ecd441aa8989b808b8580b4d') delete from  GB_AuditProblem where TaskNo = N'b1ac73c5ecd441aa8989b808b8580b4d' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'b1ac73c5ecd441aa8989b808b8580b4d') delete from  GB_ProjectPlanCombine where TaskNo = N'b1ac73c5ecd441aa8989b808b8580b4d' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from  GB_ProjectPlanTeam where TaskNo = N'b1ac73c5ecd441aa8989b808b8580b4d') delete from  GB_ProjectPlanTeam where TaskNo = N'b1ac73c5ecd441aa8989b808b8580b4d' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'b1ac73c5ecd441aa8989b808b8580b4d') delete from  GB_ProjectPlanCombine where TaskNo = N'b1ac73c5ecd441aa8989b808b8580b4d' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'b1ac73c5ecd441aa8989b808b8580b4d') delete from  GB_ProjectPlanCombine where TaskNo = N'b1ac73c5ecd441aa8989b808b8580b4d' DELETE FROM base_bizColumnattach WHERE accesspath='GB_InvalidDoc' and keyvalue in (select id from  GB_InvalidDoc where TaskNo = N'b1ac73c5ecd441aa8989b808b8580b4d') delete from  GB_InvalidDoc where TaskNo = N'b1ac73c5ecd441aa8989b808b8580b4d' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from  GB_ProjectPlanTeam where TaskNo = N'b1ac73c5ecd441aa8989b808b8580b4d') delete from  GB_ProjectPlanTeam where TaskNo = N'b1ac73c5ecd441aa8989b808b8580b4d' DELETE FROM base_bizColumnattach WHERE accesspath='GB_AuditorContactRecord' and keyvalue in (select id from  GB_AuditorContactRecord where TaskNo = N'b1ac73c5ecd441aa8989b808b8580b4d') delete from  GB_AuditorContactRecord where TaskNo = N'b1ac73c5ecd441aa8989b808b8580b4d' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'b1ac73c5ecd441aa8989b808b8580b4d') delete from  GB_ProjectPlanCombine where TaskNo = N'b1ac73c5ecd441aa8989b808b8580b4d' DELETE FROM base_bizColumnattach WHERE accesspath='GB_AuditProblem' and keyvalue in (select id from  GB_AuditProblem where TaskNo = N'b1ac73c5ecd441aa8989b808b8580b4d') delete from  GB_AuditProblem where TaskNo = N'b1ac73c5ecd441aa8989b808b8580b4d' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from  GB_ProjectPlanTeam where TaskNo = N'b1ac73c5ecd441aa8989b808b8580b4d') delete from  GB_ProjectPlanTeam where TaskNo = N'b1ac73c5ecd441aa8989b808b8580b4d' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'b1ac73c5ecd441aa8989b808b8580b4d') delete from  GB_ProjectPlanCombine where TaskNo = N'b1ac73c5ecd441aa8989b808b8580b4d' DELETE FROM base_bizColumnattach WHERE accesspath='GB_AuditorContactRecord' and keyvalue in (select id from  GB_AuditorContactRecord where TaskNo = N'b1ac73c5ecd441aa8989b808b8580b4d') delete from  GB_AuditorContactRecord where TaskNo = N'b1ac73c5ecd441aa8989b808b8580b4d' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'b1ac73c5ecd441aa8989b808b8580b4d') delete from  GB_ProjectPlanCombine where TaskNo = N'b1ac73c5ecd441aa8989b808b8580b4d' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from  GB_ProjectPlanTeam where TaskNo = N'b1ac73c5ecd441aa8989b808b8580b4d') delete from  GB_ProjectPlanTeam where TaskNo = N'b1ac73c5ecd441aa8989b808b8580b4d' DELETE FROM GB_ProjectPlan WHERE ID='512000760' DELETE FROM base_bizattach WHERE bizentityid='003002' and keyvalue='512000760' DELETE FROM base_bizColumnattach WHERE bizentityid='003002' and keyvalue='512000760' DELETE FROM base_bizattach WHERE bizentityid='008001' and keyvalue='512000760' DELETE FROM base_bizColumnattach WHERE bizentityid='008001' and keyvalue='512000760' DELETE FROM base_bizattach WHERE bizentityid='003003' and keyvalue='512000760' DELETE FROM base_bizColumnattach WHERE bizentityid='003003' and keyvalue='512000760' DELETE FROM base_bizattach WHERE bizentityid='003004' and keyvalue='512000760' DELETE FROM base_bizColumnattach WHERE bizentityid='003004' and keyvalue='512000760' DELETE FROM base_bizattach WHERE bizentityid='003005' and keyvalue='512000760' DELETE FROM base_bizColumnattach WHERE bizentityid='003005' and keyvalue='512000760' DELETE FROM base_bizattach WHERE bizentityid='006001' and keyvalue='512000760' DELETE FROM base_bizColumnattach WHERE bizentityid='006001' and keyvalue='512000760' DELETE FROM base_bizattach WHERE bizentityid='006002' and keyvalue='512000760' DELETE FROM base_bizColumnattach WHERE bizentityid='006002' and keyvalue='512000760' DELETE FROM base_bizattach WHERE bizentityid='006003' and keyvalue='512000760' DELETE FROM base_bizColumnattach WHERE bizentityid='006003' and keyvalue='512000760' DELETE FROM base_bizattach WHERE bizentityid='004003' and keyvalue='512000760' DELETE FROM base_bizColumnattach WHERE bizentityid='004003' and keyvalue='512000760' DELETE FROM base_bizattach WHERE bizentityid='004004' and keyvalue='512000760' DELETE FROM base_bizColumnattach WHERE bizentityid='004004' and keyvalue='512000760' DELETE FROM base_bizattach WHERE bizentityid='008002' and keyvalue='512000760' DELETE FROM base_bizColumnattach WHERE bizentityid='008002' and keyvalue='512000760' DELETE FROM base_bizattach WHERE bizentityid='003006' and keyvalue='512000760' DELETE FROM base_bizColumnattach WHERE bizentityid='003006' and keyvalue='512000760' DELETE FROM base_bizattach WHERE bizentityid='001035001' and keyvalue='512000760' DELETE FROM base_bizColumnattach WHERE bizentityid='001035001' and keyvalue='512000760' DELETE FROM base_bizattach WHERE bizentityid='003025' and keyvalue='512000760' DELETE FROM base_bizColumnattach WHERE bizentityid='003025' and keyvalue='512000760' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='003002' and rowid='512000760') DELETE FROM wf_workflowinstance where bizentityid='003002' and rowid='512000760' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='008001' and rowid='512000760') DELETE FROM wf_workflowinstance where bizentityid='008001' and rowid='512000760' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='003003' and rowid='512000760') DELETE FROM wf_workflowinstance where bizentityid='003003' and rowid='512000760' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='003004' and rowid='512000760') DELETE FROM wf_workflowinstance where bizentityid='003004' and rowid='512000760' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='003005' and rowid='512000760') DELETE FROM wf_workflowinstance where bizentityid='003005' and rowid='512000760' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='006001' and rowid='512000760') DELETE FROM wf_workflowinstance where bizentityid='006001' and rowid='512000760' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='006002' and rowid='512000760') DELETE FROM wf_workflowinstance where bizentityid='006002' and rowid='512000760' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='006003' and rowid='512000760') DELETE FROM wf_workflowinstance where bizentityid='006003' and rowid='512000760' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='004003' and rowid='512000760') DELETE FROM wf_workflowinstance where bizentityid='004003' and rowid='512000760' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='004004' and rowid='512000760') DELETE FROM wf_workflowinstance where bizentityid='004004' and rowid='512000760' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='008002' and rowid='512000760') DELETE FROM wf_workflowinstance where bizentityid='008002' and rowid='512000760' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='003006' and rowid='512000760') DELETE FROM wf_workflowinstance where bizentityid='003006' and rowid='512000760' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='001035001' and rowid='512000760') DELETE FROM wf_workflowinstance where bizentityid='001035001' and rowid='512000760' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='003025' and rowid='512000760') DELETE FROM wf_workflowinstance where bizentityid='003025' and rowid='512000760' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='003002' and rowid='512000760') DELETE FROM wf_bizflowinstance where bizentityid='003002' and rowid='512000760' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='008001' and rowid='512000760') DELETE FROM wf_bizflowinstance where bizentityid='008001' and rowid='512000760' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='003003' and rowid='512000760') DELETE FROM wf_bizflowinstance where bizentityid='003003' and rowid='512000760' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='003004' and rowid='512000760') DELETE FROM wf_bizflowinstance where bizentityid='003004' and rowid='512000760' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='003005' and rowid='512000760') DELETE FROM wf_bizflowinstance where bizentityid='003005' and rowid='512000760' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='006001' and rowid='512000760') DELETE FROM wf_bizflowinstance where bizentityid='006001' and rowid='512000760' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='006002' and rowid='512000760') DELETE FROM wf_bizflowinstance where bizentityid='006002' and rowid='512000760' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='006003' and rowid='512000760') DELETE FROM wf_bizflowinstance where bizentityid='006003' and rowid='512000760' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='004003' and rowid='512000760') DELETE FROM wf_bizflowinstance where bizentityid='004003' and rowid='512000760' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='004004' and rowid='512000760') DELETE FROM wf_bizflowinstance where bizentityid='004004' and rowid='512000760' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='008002' and rowid='512000760') DELETE FROM wf_bizflowinstance where bizentityid='008002' and rowid='512000760' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='003006' and rowid='512000760') DELETE FROM wf_bizflowinstance where bizentityid='003006' and rowid='512000760' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='001035001' and rowid='512000760') DELETE FROM wf_bizflowinstance where bizentityid='001035001' and rowid='512000760' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='003025' and rowid='512000760') DELETE FROM wf_bizflowinstance where bizentityid='003025' and rowid='512000760'

2025-12-08 17:13:55 执行时长：5.04秒 sql:delete from base_bizcolumnattach where AccessPath='GB_CertiApplyApproveDoc' and KeyValue='512001731' and DataColumnID='002168' insert into base_bizcolumnattach (id,bizentityid,keyvalue,DataColumnID,filename,createby,accesspath)  values ('2002128130f5d754b87','000020014','512001731','002168','ISC-QR-R-06 申请评审及审核方案策划表.docx','夏僧道','GB_CertiApplyApproveDoc')