/* */ --更新订单商品表; update dindansp set [no] = replace([no], '|', ';'), [no2] = replace([no2], '|', ';') --更新订单表; update dindan set [delphotos] = replace([delphotos], '|', ';'),[delphotos2] = replace([delphotos2],'|',';')