Hi I have a table named test and a column named technologyid. Now this column is the primary key of the table
but at the same time, this column is also the foreign key referencing to another table. I know this is weird but this is how the table has been designed.
Now, I have a requirement to insert some records and these are existing technologyid's and it throws the below error.
Msg 2627, Level 14, State 1, Line 1
Violation of PRIMARY KEY constraint 'PK_TechnologyAttributes'. Cannot insert duplicate key in object 'dbo.TechnologyAttributes'. The duplicate key value is (666).
The statement has been terminated.
Is there any way to get around this ?
Microsoft SQL Server 2008Microsoft SQL Server 2005Microsoft SQL Server