SQL Server: How do you insert rows where some rows might have duplicate keys?

Asked Aug 31 '18 at 13:23

Active Aug 31 '18 at 13:23

Viewed 31 times

I need to insert dozens of rows, but my table has a unique key and some of the inserted rows might have the same unique key as existing rows in the table.

How can I safely instruct the database to only insert the rows that don't contain duplicate keys, and ignore the duplicates?

(I was thinking along the lines of INSERT ... WHERE NOT EXISTS ... but I don't think it's possible?)

asked Aug 31 '18 at 13:23

Giffyguy

17,946
30
81
147

1

You could use an INSERT INTO .... SELECT. The source for the select data doesn't need to be a table. – Ralf Aug 31 '18 at 13:26
@Ralf Ahhh, that was the piece I was missing. That makes perfect sense. Thanks! – Giffyguy Aug 31 '18 at 13:27

SQL Server: How do you insert rows where some rows might have duplicate keys?

0 Answers0