Question

On an Insert statement, I receive the following error - "Violation of Primary Key Constraint. Cannot Insert Duplicate Key in object." What has happened? 1) I have executed a statement that includes a foreign key column(s) 2) I have executed a statement that has a duplicate value in the primary key column(s) 3) I have executed a statement that has a duplicate value in a column(s) 4) SQL Server Management Studio is not connected

          On an Insert statement, I receive the following error -
"Violation of Primary Key Constraint. Cannot Insert Duplicate Key
in object." What has happened?
1) I have executed a statement that includes a foreign key
column(s)
2) I have executed a statement that has a duplicate value in the
primary key column(s)
3) I have executed a statement that has a duplicate value in a
column(s)
4) SQL Server Management Studio is not connected

Added by Mohamed M.

Computer Science and Information Technology

Trishna Knowledge Systems 2018 Edition

Instant Answer

Solved by Expert Joy Densmore

Step 1

The error message states that there is a violation of the primary key constraint, which means that the primary key column(s) already contain a value that is being inserted again. Show more…

Show all steps

Thanks for your feedback!

On an Insert statement, I receive the following error - "Violation of Primary Key Constraint. Cannot Insert Duplicate Key in object." What has happened? 1) I have executed a statement that includes a foreign key column(s) 2) I have executed a statement that has a duplicate value in the primary key column(s) 3) I have executed a statement that has a duplicate value in a column(s) 4) SQL Server Management Studio is not connected