StringBuffer returnValue = new StringBuffer(300);
returnValue.append(" INSERT INTO vehicle_charge_temp( ");
returnValue.append(" RELATION_ID,");//费用关联编号
returnValue.append(" VEHICLE_NO,");//
returnValue.append(" EMPLOYEE_CODE )");//
returnValue.append(" (SELECT ");
returnValue.append(" RELATION_ID,");//费用关联编号
returnValue.append(" VEHICLE_NO,");//
returnValue.append(" EMPLOYEE_CODE ");//
returnValue.append(" FROM vehicle_charge ");
returnValue.append(" WHERE ");
returnValue.append(" RELATION_ID='"+accident_code+"')");
return returnValue.toString();
临时表与正式表之间的复制
最新推荐文章于 2022-10-26 19:57:08 发布