避免重复插入数据sql server

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')

posted @ 2018-02-23 14:12  二斌  阅读(2327)  评论(0编辑  收藏  举报