达梦8
SQLserver迁移到达梦8,下面这段sql要怎么改到达梦里也能实现同样功能
–创建临时表
select cert_id
into #cert_id_temp
from pdgxk.permit_cert a,pdgxk.enty_info b
where a.data_source = ‘3’
and a.enty_id = b.enty_id
and a.update_time > (select max(SJC) from pdgxk.permit_cert_shuanggongshi);
–查出删除数据信息
delete from PDGXK.permit_cert_shuanggongshi
where cert_id in
(
select * from #cert_id_temp
);