SQL SERVER PRIMARY-KEY WITH IGNORE-DUP-KEY

ALTER TABLE [SCHEMA].[TABLE_NAME]
  ADD CONSTRAINT PK_NAME  
  PRIMARY KEY (PK_FIELD) WITH ( IGNORE_DUP_KEY = ON )
GO