sql server

Hi all,
I have a problem that need to solve: I have a table that is called empVisit.
There was a error when inserting: Violation of PRIMARY KEY constraint 'PK_EmpVisit'. Cannot insert duplicate key in object 'dbo.EmpVisit'.
The statement has been terminated.
PRIMARY KEY is Id field of the table. I need to insert a new record with the same Id value to that table.
So how to solve this problem?
Pls help me, thanks in advance,

--Ha

re: sql server

You should start thinking about why you really want to insert the same ID twice. you most probably have a badly designed database and/or program.

Regards,

Alex.

re: sql server

So, there is no way to solve this problem, right?

re: sql server

Absolutely. There is no way you can possibly solve this huge monster of a problem. Not in 100 years.

Regards,

Alex.

re: sql server

Anyway, thanks for your answer, Alex

Ha

re: sql server

Why do you need to insert a duplicate key?
Do you just want to update the other values instead?
If you do need to have many records with the same value in the key field then your key constraint is not correct and should be removed.