create table #t (i int not null);

create unique index UQ on #t(i) with ignore_dup_key;

insert #t values (1),(1),(2),(2);

Duplicate key was ignored.

(2 row(s) affected)