You are a DBA that must load 100,000 rows to an existing table. Your insert statement fails with a primary

You are a DBA that must load 100,000 rows to an existing table. Your insert statement fails with a primary

Question:

You are a DBA that must load 100,000 rows to an existing table. Your insert statement fails with a primary key constraint error. What method or query could you use to determine the primary key violations? There are many possible solutions to this question. Use an example to clarify your answer.

Expert Answer:

Answer rating: 100% (QA)

Let s assume you have an existing table called employees with a primary key constraint on the employee id column 1 Begin a Transaction Optional but re
View the full answer