Create a stored procedure hidden in the index sqlserver that ignores the repetition value

CREATE UNIQUE NONCLUSTERED INDEX IX_PARTINFOTMP on Partinfotmp

(

Id

) With ignore_dup_key on [primary]

Go

INSERT INTO ....

You can go to the repeated record in the table.