sql server:
if not exists (select 1 from TB_Procedure where Id=‘2018ZZZ‘)
BEGIN
insert into TB_Procedure
(Id,IsStart,IsCNC,IsClean,IsMarking,IsLT,IsGil,IsCheck,IsFinalCheck,IsGP12,IsPackaging)
values
( ‘2018ZZZ‘,‘‘,‘‘,‘‘,‘‘,‘‘,‘‘,‘‘,‘‘,‘‘,‘‘);
END
oracle:
insert into kszx_xjtm (id,unitid)
SELECT 1,‘1‘ FROM dual WHERE not exists
(select * from kszx_xjtm where tmid = ‘1‘ )
SQLSERVER 和 ORACLE的if not exist 用法
标签:sel scn oracle pac HERE star sql procedure exist
本条技术文章来源于互联网,如果无意侵犯您的权益请点击此处反馈版权投诉 本文系统来源:https://www.cnblogs.com/MagicAsa/p/10185527.html