Collections:
Duplicate Key Error on Primary Key Columns in SQL Server
What Happens If You Insert a Duplicate Key for the Primary Key Column in SQL Server?
✍: FYIcenter.com
If your table has a primary key column, and you are trying to insert a new row with duplicate key value on the primary key column, you will get an error. The reason is simple - Primary key column does not allow duplicate values. The following tutorial exercise gives you a good example:
SELECT * FROM fyi_links INSERT INTO fyi_links VALUES (101, 'sql.fyicenter.com', NULL, 0, '2006-04-30') GO Msg 2627, Level 14, State 1, Line 1 Violation of PRIMARY KEY constraint 'PK__fyi_links__03317E3D'. Cannot insert duplicate key in object 'dbo.fyi_links'. The statement has been terminated.
You are getting this error, because value "101" has already been used by an existing row.
2016-11-02, 745👍, 0💬
Popular Posts:
How To Count Rows with the COUNT(*) Function in SQL Server? If you want to count the number of rows,...
How do you know if SQL Server is running on your local system in SQL Server? After installing SQL Se...
How To Enter Unicode Character String Literals in SQL Server Transact-SQL? Unicode characters are mu...
How To Execute a Stored Procedure in SQL Server Transact-SQL? If you want execute a stored procedure...
How To Create an Multi-Statement Table-Valued Function in SQL Server Transact-SQL? To create a multi...