数据库间指定表的数据导入

语法：

insert into A 
select * from B

注意两个表栏位不同,是不可以


INSERT INTO [tongshan_conv].[dbo].[t_department]
           ([Depa_Id]
,[Depa_Dist_No]
           ,[Depa_No]
           
           ,[Depa_Name]
           ,[Depa_Flag]
 ,[is_Convenience]
           ,[Depa_Leader]
          )


SELECT DEPTID as Depa_Id,
'1' as Depa_dist_no,
			
DEPTCODE as Depa_No,
DEPTNAME as Depa_Name,
(case when ENABLE='启用' then 'Y' else 'N' end) as Depa_Flag,
			deptType as is_Convenience ,
PARENTID as Depa_Leader FROM  [fuNan_web].[dbo].T_DEPARTMENT WHERE DEPTID<244