一个表导入到另一个表

  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]

posted on 2014-10-23 18:02  中子持心  阅读(148)  评论(0编辑  收藏  举报

导航