恢复在制品步骤

恢复在制品而不是半成品，按照以下顺序

1.恢复t_lotpf表

COPY t_lotpf(ID_LOTPF,ET_ETALOT,LOTPF_QTE,LOTPF_COMMENT,LOTPF_NO_ETIQUETTE,LOTPF_DEB_VALIDITE,LOTPF_FIN_VALIDITE,NOMMODIF,DATEMODIF,HEUREMODIF,et_prod,LOTPF_NUMORDER)
FROM 'C:/Temp/csvConvert/t_lotpf.csv'
WITH (FORMAT CSV, HEADER);

2.恢复t_stocpf表

COPY t_stocpf(ID_STOCPF,ET_LOTPF,ET_REFCMP,STOCPF_NO_CLI,STOCPF_NBIMPRESSION,ET_QUALPF,STOCPF_CREATION,NOMMODIF,DATEMODIF,HEUREMODIF,STOCPF_LINE,STOCPF_IMPRESSION,STOCPF_NUMORDER,STOCPF_TYPORDER,STOCPF_LASTSTA,STOCPF_REPORT_NUMORDER,ET_SHIFT,STOCPF_FINISH_DATE)
FROM 'C:/Temp/csvConvert/t_stocpf2.csv'
WITH (FORMAT CSV, HEADER);

3.恢复t_operat表

COPY t_operat (ET_SIMO,ET_STOCPF,OPERAT_NO_PASSAGE,OPERAT_NSCOMP,OPERAT_STATUT,NOMMODIF,DATEMODIF,HEUREMODIF,ET_ETATOP,OPERAT_CREATION,OPERAT_COMP_NO_PASSAGE,time_stamp,ET_STOCPF_SUBASSY)
FROM 'C:/Temp/csvConvert/output2.csv'
WITH (FORMAT CSV, HEADER);