从一个表导数据到另外一个表，但是字段不同

with a as

(

SELECT

[ReadName]

,[LoginName]

,[LoginPwd]

,[RoseID]

,[SectorID]

,[CreateTime]

,[LastDate]

,[TopDate]

,[IsEnable]

,[Remark] from sysUSER

)

insert into [Manage].[dbo].[Sys_User]([UName],[TrueName],[UPassWord],[RID],[DID],[CreateTime],[LastTime],[ThisTime],[IsEnable] ,[Remarks]) select * from a