Insert into Table2(field1,field2,...) select value1,value2,... from Table1
insert into [Asset].[dbo].[hx_tblSite]      ([CreateDate],[IsAvailable],[SiteCode],[SiteName],[SiteAlias]        ,[SiteY],[SiteX],[BaseStation],[Location],[Remark])     select  GETDATE(),'True',[F8],[F9],[F10],          [F12],[F11],[F1],[F7],[F16]                      from [Asset].[dbo].[基站$]