INSERT INTO语句中直接插入一条SELECT语句

INSERT INTO语句中直接插入一条SELECT语句

这样可以直接插入一条完整的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 +"')";