语法:
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