摘要： 将SQL从一个表中查询的结果集插入到另一个数据表中，操作如下：1、若插入的是部分字段，语句如下：insert into Commodity(A,B,C) SELECT 'Bios' as A,[Win8] as B, [A-Rev] as C FROM [SRVPDL].[dbo].[Win8_test] where [F16] is not null2、若插入新表全部的字段，语句如下： insert into CommoditySELECT 'Bios' as A,[Win8] as B, [A-Rev] as C FROM [SRVPDL].[dbo].[W 阅读全文