[MSSQL] INSERT NOT EXISTS

 

https://mitch.codes/sql-tip-insert-where-not-exists/

SQL Tip - Insert where not exists - Mitch Valenta

 

SELECT 문의 결과값이 없을 경우에 INSERT 하는 방법.

 

INSERT INTO dbo.table (field) 
SELECT 'field'
WHERE NOT EXISTS 
    (SELECT field 
     FROM dbo.table
     WHERE field = 'field')

 

INSERT INTO dbo.Customer (firstname, lastname, phone) 
SELECT 'Mitch', 'Valenta', '555-867-5309'
WHERE NOT EXISTS 
    (SELECT firstname, lastname 
     FROM dbo.Customer 
     WHERE firstname = 'Mitch' AND lastname = 'Valenta')