Exception Handling at the Table Level

I got a very interesting question from my client asking about the way to implement exception handling at the table level, that is if we insert duplicate records into a table then SQL Server should not throw any Primary Key violation errors. This is very interesting and challenging question.