這樣可以直接插入一條完整的SELECT語句中的所以的數據。  strsql="insert into t_mb_jxjhkcb(id,jxjhbh,xn,xq,jxzlx,jxzs,kcbh,zks) SELECT CAST(RTRIM(id) AS varchar(30)) + '1 ' AS id, '"+ str_jxjhbh +"' AS jxjhbh, xn,xq,jxzlx,jxzs,kcbh,zks FROM t_mb_jxjhkcb WHERE (jxjhbh = '"+ str_jxjhbh_old +"')";