![SQL SERVER - Unique Nonclustered Index Creation with IGNORE_DUP_KEY = ON - SQL Authority with Pinal Dave SQL SERVER - Unique Nonclustered Index Creation with IGNORE_DUP_KEY = ON - SQL Authority with Pinal Dave](https://blog.sqlauthority.com/i/b/ignoredup1.jpg)
SQL SERVER - Unique Nonclustered Index Creation with IGNORE_DUP_KEY = ON - SQL Authority with Pinal Dave
![primary key - How to get the ignored row while IGNORE_DUP_KEY is ON on SQL Server? - Database Administrators Stack Exchange primary key - How to get the ignored row while IGNORE_DUP_KEY is ON on SQL Server? - Database Administrators Stack Exchange](https://i.stack.imgur.com/rXGfJ.png)
primary key - How to get the ignored row while IGNORE_DUP_KEY is ON on SQL Server? - Database Administrators Stack Exchange
![How to avoid re-inserting data (duplicates) into SQL Server table while re-running SSIS package that loads data? - Stack Overflow How to avoid re-inserting data (duplicates) into SQL Server table while re-running SSIS package that loads data? - Stack Overflow](https://i.stack.imgur.com/rT7Z6.png)
How to avoid re-inserting data (duplicates) into SQL Server table while re-running SSIS package that loads data? - Stack Overflow
![SQL SERVER - Unique Nonclustered Index Creation with IGNORE_DUP_KEY = ON - SQL Authority with Pinal Dave SQL SERVER - Unique Nonclustered Index Creation with IGNORE_DUP_KEY = ON - SQL Authority with Pinal Dave](https://blog.sqlauthority.com/i/b/ignoredup2.jpg)