--项目select*into bd_project_temp from bd_project
--销售合同select*into jych_xshtdj_temp from jych_xshtdj;select*into jych_xshtdj_b_temp from jych_xshtdj_b;select*into jych_xshtdj_c_temp from jych_xshtdj_c;select*into jych_xshtdj_d_temp from jych_xshtdj_d;select*into jych_xshtdj_e_temp from jych_xshtdj_e;select*into jych_xshtdj_f_temp from jych_xshtdj_f;--开票申请select*into jych_kpsq_temp from jych_kpsq;select*into jych_kpsq_b_temp from jych_kpsq_b;--收款单select*into jych_receiptvoucher_temp from jych_receiptvoucher;select*into jych_receiptvoucher_b_temp from jych_receiptvoucher_b;
2.从原表查备份表中没有的记录
select htcode from jych_xshtdj
exceptselect htcode from jych_xshtdj_temp