一个表导入到另一个表
delete FROM [GCSDB_ZYB].[dbo].[EMPLOYEES]
SET IDENTITY_INSERT [GCSDB_ZYB].[dbo].[EMPLOYEES] on
insert [GCSDB_ZYB].[dbo].[EMPLOYEES] (
[PK_EMPLOYEE_ID]
,[FK_EMPLOYEE_TYPE_ID]
,[ORG_NO]
,[EMPLOYEE_COMPANY]
,[EMPLOYEE_CODE]
,[EMPLOYEE_NAME]
,[EMPLOYEE_NAME_PY]
,[EMPLOYEE_SHORT_NAME_PY]
,[EMPLOYEE_SEX]
,[EMPLOYEE_BIRTHDAY]
,[EMPLOYEE_WORK_ADRESS]
,[EMPLOYEE_DEPARTMENT]
,[EMPLOYEE_DEPT_ID]
,[EMPLOYEE_DEPT_PARENT_ID]
,[EMPLOYEE_DEPT_ID_PATH]
,[EMPLOYEE_DEPT_NAME_PATH]
,[EMPLOYEE_IS_FAIL]
,[EMPLOYEE_IS_ATTENDANCER]
,[EMPLOYEE_JOB]
,[EMPLOYEE_TEL]
,[EMPLOYEE_BP]
,[EMPLOYEE_HOSTEL_TEL]
,[EMPLOYEE_LOACATION_TEL]
,[EMPLOYEE_WORK_TEL]
,[EMPLOYEE_FAX]
,[EMPLOYEE_EMAIL]
,[EMPLOYEE_OUT_EMAIL]
,[EMPLOYEE_PHOTO]
,[EMPLOYEE_STAFF_ID]
,[EMPLOYEE_CREATE_USER]
,[EMPLOYEE_VALID_START_TIME]
,[EMPLOYEE_VALID_END_TIME]
,[EMPLOYEE_USE_VIRTUAL_HUMAN]
)
select * from [GCSDB_4].[dbo].[EMPLOYEES]