INSERT INTO MySalesReason
SELECT SalesReasonID, Name, ModifiedDate
FROM AdventureWorks.Sales.SalesReason
WHERE ReasonType = N'Marketing';
SELECT SalesReasonID, Name, ModifiedDate
FROM MySalesReason;
子查询的选择列表必须与 INSERT 语句的列列表匹配。如果没有指定列列表，选择列表必须与正在其中执行插入操作的表或视图的列匹配。
String insertsql = "insert into t_windowsDetails (applicationname,winname,devicename,"
+ "lx,ly,lwidth,lheight,lxunit,lyunit,px,py,pwidth,pheight,pxunit,pyunit,fontresize,fontadjust) "
+ "select '"
+
applicationname
+ "',
'default',"
+ "devicename,lx,ly,lwidth,lheight,lxunit,lyunit,px,py,pwidth,pheight,pxunit,pyunit,fontresize,fontadjust "
+ "from t_windowsDetails where applicationname='default' and winname='default' and devicename='"
+ devicename
+ "'";
上面的applicationname是java中的变量，‘default’是常量值。后面的是表中的列。这样拼接完成insert和select子查询。
