备份表、从原表查备份表中没有的记录

1.备份表

--项目
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
except
select htcode from jych_xshtdj_temp