83 lines
2.1 KiB
Transact-SQL
83 lines
2.1 KiB
Transact-SQL
INSERT INTO [dbo].[Sys_Menu]
|
|
SELECT * FROM HJGLDB_ZHJAN.dbo.Sys_Menu
|
|
GO
|
|
INSERT INTO [dbo].[Sys_Role]
|
|
SELECT * from HJGLDB_ZHJAN.dbo.Sys_Role
|
|
GO
|
|
INSERT INTO [dbo].[Sys_ButtonPower]
|
|
SELECT * FROM HJGLDB_ZHJAN.dbo.Sys_ButtonPower
|
|
GO
|
|
INSERT INTO dbo.ButtonToMenu
|
|
SELECT * FROM HJGLDB_ZHJAN.dbo.ButtonToMenu
|
|
GO
|
|
INSERT INTO dbo.Sys_System
|
|
SELECT * FROM HJGLDB_ZHJAN.dbo.Sys_System
|
|
GO
|
|
INSERT INTO dbo.Sys_RolePower
|
|
SELECT * FROM HJGLDB_ZHJAN.dbo.Sys_RolePower
|
|
GO
|
|
INSERT INTO dbo.Sys_Const
|
|
SELECT * FROM HJGLDB_ZHJAN.dbo.Sys_Const
|
|
GO
|
|
INSERT INTO dbo.HJGL_BS_Equipment
|
|
SELECT * FROM HJGLDB_ZHJAN.dbo.HJGL_BS_Equipment
|
|
GO
|
|
INSERT INTO dbo.HJGL_BS_ExecStandard
|
|
SELECT * FROM HJGLDB_ZHJAN.dbo.HJGL_BS_ExecStandard
|
|
GO
|
|
INSERT INTO dbo.HJGL_BS_IsoClass
|
|
SELECT * FROM HJGLDB_ZHJAN.dbo.HJGL_BS_IsoClass
|
|
GO
|
|
INSERT INTO dbo.HJGL_BS_JointType
|
|
SELECT * FROM HJGLDB_ZHJAN.dbo.HJGL_BS_JointType
|
|
GO
|
|
INSERT INTO dbo.HJGL_BS_NDTRate
|
|
SELECT * FROM HJGLDB_ZHJAN.dbo.HJGL_BS_NDTRate
|
|
GO
|
|
INSERT INTO dbo.HJGL_BS_NDTType
|
|
SELECT * FROM HJGLDB_ZHJAN.dbo.HJGL_BS_NDTType
|
|
GO
|
|
INSERT INTO dbo.HJGL_BS_SchTab
|
|
SELECT * FROM HJGLDB_ZHJAN.dbo.HJGL_BS_SchTab
|
|
GO
|
|
INSERT INTO dbo.HJGL_BS_Service
|
|
SELECT * FROM HJGLDB_ZHJAN.dbo.HJGL_BS_Service
|
|
GO
|
|
INSERT INTO dbo.HJGL_BS_SlopeType
|
|
SELECT * FROM HJGLDB_ZHJAN.dbo.HJGL_BS_SlopeType
|
|
GO
|
|
INSERT INTO dbo.HJGL_BS_WeldControl
|
|
SELECT * FROM HJGLDB_ZHJAN.dbo.HJGL_BS_WeldControl
|
|
GO
|
|
INSERT INTO dbo.HJGL_BS_WeldMaterial
|
|
SELECT * FROM HJGLDB_ZHJAN.dbo.HJGL_BS_WeldMaterial
|
|
GO
|
|
INSERT INTO dbo.HJGL_BS_WeldMethod
|
|
SELECT * FROM HJGLDB_ZHJAN.dbo.HJGL_BS_WeldMethod
|
|
GO
|
|
|
|
INSERT INTO dbo.HJGL_BS_Steel
|
|
SELECT * FROM HJGLDB_ZHJAN.dbo.HJGL_BS_Steel
|
|
GO
|
|
INSERT INTO dbo.HJGL_BS_TestStandard
|
|
SELECT * FROM HJGLDB_ZHJAN.dbo.HJGL_BS_TestStandard
|
|
GO
|
|
|
|
|
|
|
|
INSERT INTO dbo.HJGL_BS_MaterialCompare
|
|
SELECT * FROM HJGLDB_ZHJAN.dbo.HJGL_BS_MaterialCompare
|
|
GO
|
|
INSERT INTO dbo.HJGL_BS_MaterialStandard
|
|
SELECT * FROM HJGLDB_ZHJAN.dbo.HJGL_BS_MaterialStandard
|
|
GO
|
|
|
|
INSERT INTO dbo.Common_ReportServer
|
|
SELECT * FROM HJGLDB_ZHJAN.dbo.Common_ReportServer WHERE projectId='0'
|
|
GO
|
|
INSERT INTO dbo.Sys_User
|
|
SELECT * FROM HJGLDB_ZHJAN.dbo.Sys_User WHERE Account='gly'
|
|
GO
|
|
|
|
|