首页 > 技术文章 > 避免重复插入数据sql server

shihaibin821 2018-02-23 14:12 原文

insert into TN_JOBS(JAVA_ID,SERVER_IP,SERVER_PORT,JOB_CODE,JOB_NAME,JOB_START_TIME,JOB_MSG,JOB_STATUS,JOB_END_TIME)
SELECT 'JOB001','','','','','','','',''
where not exists
(select * from TN_JOBS b where b.JAVA_ID='JOB001')

推荐阅读