SQLSERVER 和 ORACLE的if not exist 用法

sql server:

1
2
3
4
5
6
7
8
  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:

1
2
3
insert into kszx_xjtm (id,unitid)  
SELECT 1,'1' FROM dual WHERE not exists 
(select * from kszx_xjtm where tmid = '1' )

  

posted @   MagicAsa  阅读(2413)  评论(0编辑  收藏  举报
努力加载评论中...
点击右上角即可分享
微信分享提示