Basf_TCC7/DataBase/数据导入.txt

21 lines
1.3 KiB
Plaintext

INSERT INTO Base_Components SELECT * FROM HJGLDB_WH.dbo.Base_Components
INSERT INTO Base_Consumables SELECT * FROM HJGLDB_WH.dbo.Base_Consumables
INSERT INTO Base_Defect SELECT * FROM HJGLDB_WH.dbo.Base_Defect
INSERT INTO Base_DetectionRate SELECT * FROM HJGLDB_WH.dbo.Base_DetectionRate
INSERT INTO Base_DetectionType SELECT * FROM HJGLDB_WH.dbo.Base_DetectionType
INSERT INTO Base_GrooveType SELECT * FROM HJGLDB_WH.dbo.Base_GrooveType
INSERT INTO Base_Material SELECT * FROM HJGLDB_WH.dbo.Base_Material
INSERT INTO Base_Medium SELECT * FROM HJGLDB_WH.dbo.Base_Medium
INSERT INTO Base_PipingClass SELECT * FROM HJGLDB_WH.dbo.Base_PipingClass
INSERT INTO Base_Pressure SELECT * FROM HJGLDB_WH.dbo.Base_Pressure
INSERT INTO Base_UnitType SELECT * FROM HJGLDB_WH.dbo.Base_UnitType
INSERT INTO Base_WeldingLocation SELECT * FROM HJGLDB_WH.dbo.Base_WeldingLocation
INSERT INTO Base_WeldingMethod SELECT * FROM HJGLDB_WH.dbo.Base_WeldingMethod
INSERT INTO Base_WeldType SELECT * FROM HJGLDB_WH.dbo.Base_WeldType
INSERT INTO Common_ReportServer SELECT * FROM HJGLDB_WH.dbo.Common_ReportServer
INSERT INTO Sys_Menu SELECT * FROM HJGLDB_WH.dbo.Sys_Menu
INSERT INTO Sys_ButtonToMenu SELECT * FROM HJGLDB_WH.dbo.Sys_ButtonToMenu
INSERT INTO Sys_Role SELECT * FROM HJGLDB_WH.dbo.Sys_Role
INSERT INTO Sys_User SELECT * FROM HJGLDB_WH.dbo.Sys_User WHERE Account='gly'