42 lines
2.4 KiB
Transact-SQL
42 lines
2.4 KiB
Transact-SQL
INSERT INTO SGGLDB.dbo.Law_HSSEStandardsList SELECT * FROM SUBHSSEDB.DBO.Law_HSSEStandardsList
|
|
GO
|
|
INSERT INTO SGGLDB.dbo.InformationProject_ConstructionStandardIdentify SELECT * FROM SUBHSSEDB.DBO.InformationProject_ConstructionStandardIdentify
|
|
WHERE ProjectId IN (SELECT ProjectId FROM SGGLDB.dbo.Base_Project)
|
|
GO
|
|
INSERT INTO SGGLDB.dbo.InformationProject_ConstructionStandardSelectedItem SELECT * FROM SUBHSSEDB.DBO.InformationProject_ConstructionStandardSelectedItem
|
|
WHERE ConstructionStandardIdentifyId IN (SELECT ConstructionStandardIdentifyId FROM SGGLDB.dbo.InformationProject_ConstructionStandardIdentify)
|
|
GO
|
|
|
|
INSERT INTO SGGLDB.dbo.ActionPlan_ManagerRule SELECT * FROM SUBHSSEDB.DBO.ActionPlan_ManagerRule
|
|
WHERE ProjectId IN (SELECT ProjectId FROM SGGLDB.dbo.Base_Project)
|
|
GO
|
|
INSERT INTO SGGLDB.dbo.Law_ManageRule SELECT * FROM SUBHSSEDB.DBO.Law_ManageRule
|
|
GO
|
|
INSERT INTO SGGLDB.dbo.Law_RulesRegulations SELECT * FROM SUBHSSEDB.DBO.Law_RulesRegulations
|
|
GO
|
|
INSERT INTO SGGLDB.dbo.ActionPlan_ActionPlanList SELECT * FROM SUBHSSEDB.DBO.ActionPlan_ActionPlanList
|
|
WHERE ProjectId IN (SELECT ProjectId FROM SGGLDB.dbo.Base_Project)
|
|
GO
|
|
INSERT INTO SGGLDB.dbo.QualityAudit_SubUnitQuality SELECT * FROM SUBHSSEDB.DBO.QualityAudit_SubUnitQuality
|
|
GO
|
|
INSERT INTO SGGLDB.dbo.QualityAudit_SubUnitQualityAuditDetail SELECT * FROM SUBHSSEDB.DBO.QualityAudit_SubUnitQualityAuditDetail
|
|
WHERE ProjectId IN (SELECT ProjectId FROM SGGLDB.dbo.Base_Project)
|
|
GO
|
|
INSERT INTO SGGLDB.dbo.HSSESystem_HSSEMainDuty SELECT * FROM SUBHSSEDB.DBO.HSSESystem_HSSEMainDuty
|
|
GO
|
|
INSERT INTO SGGLDB.dbo.Resources_SignManage SELECT * FROM SUBHSSEDB.DBO.Resources_SignManage
|
|
GO
|
|
INSERT INTO SGGLDB.dbo.Training_Training SELECT * FROM SUBHSSEDB.DBO.Training_Training
|
|
GO
|
|
INSERT INTO SGGLDB.dbo.Training_TrainingItem SELECT * FROM SUBHSSEDB.DBO.Training_TrainingItem
|
|
GO
|
|
INSERT INTO SGGLDB.dbo.Training_CompanyTraining SELECT * FROM SUBHSSEDB.DBO.Training_CompanyTraining
|
|
GO
|
|
INSERT INTO SGGLDB.dbo.Training_CompanyTrainingItem SELECT * FROM SUBHSSEDB.DBO.Training_CompanyTrainingItem
|
|
GO
|
|
INSERT INTO SGGLDB.dbo.Training_TestTrainingItem (TrainingItemId,TrainingId,TrainingItemCode,TrainingItemName,Abstracts,AttachUrl
|
|
,VersionNum,TestType,WorkPostIds,WorkPostNames,AItem,BItem,CItem,DItem,EItem,AnswerItems)
|
|
SELECT TrainingItemId,TrainingId,TrainingItemCode,TrainingItemName,Abstracts,AttachUrl
|
|
,VersionNum,TestType,WorkPostIds,WorkPostNames,AItem,BItem,CItem,DItem,EItem,AnswerItems
|
|
FROM SUBHSSEDB.DBO.Training_TestTrainingItem
|
|
GO |