日期:2014-05-17 浏览次数:21098 次
    insert into dmitem@itf_jst(
      consignor_code, item_code, item_name, barcode, opcode, formulation, supplier_city,
      item_bigsort, item_hitsort, inner_code, pack_no, package_number, bigpackage_number,
      big_weight, big_length, big_width, big_height, weight, length, width, height, 
      storage_conditions, consignor_item_name, specifications, supplier_code, approval_number,
      trademark, item_unit, item_cess, trade_price, retail_price, maintenance_cycle, 
      item_validity, state, isstimulant, specialsort, isbatchs, isimport, isregulation, isbirth,
      isexamine, istrack, isconsrelease, remark)
    select
      consignor_code, item_code, item_name, barcode, "OPCODE", formulation, supplier_city,
      item_bigsort, item_hitsort, inner_code, pack_no, package_number, bigpackage_number,
      big_weight, big_length, big_width, big_height, weight, length, width, height, 
      storage_conditions, consignor_item_name, specifications, supplier_code, approval_number,
      trademark, item_unit, item_cess, trade_price, retail_price, maintenance_cycle, 
      item_validity, state, isstimulant, specialsort, isbatchs, isimport, isregulation, isbirth,
      isexamine, istrack, isconsrelease, remark
    from 
      jst_view_article;