sql 复制一个表中记录到另一个表

insert into sys_dict (SD_ID ,SD_CODE,SD_DESCRIPTION,SD_PARENT_ID,SD_PATH,SD_ORDER,SD_MODULE) 


select 
[SP_ID],
[SP_SCODE],
[SP_INFO],
'65B321B9C5F448108F6527FF3D270870' as SD_PARENT_ID,
('65B321B9C5F448108F6527FF3D270870,'+[SP_ID]) as SD_PATH,
[SP_SCODE],
[SP_CODE]
from SYS_PAGEVAR 
where sp_code ='民族代码'