Posted on 2002-06-26
Saying 2 same tables, exept the first one as not any primary key or indexes because there are duplicate rows.
To avoid this, i copy it in the second one :
INSERT INTO Table2
I obtain :
Server : Msg 2627, Level 14, State 1, Line2
Violation of Primary Key constraint ..........
However, when just selecting rows (without INSERT), i obtain all rows without any duplicate.