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