User Profile
Collapse
Profile Sidebar
Collapse
datawise
Last Activity: Feb 27 '14, 06:09 PM
Joined: Feb 26 '14
Location:
-
SQL Server Violation of Primary Key
I have a table, "SOME_TABLE ", with a clustered primary key on a character column, "XYZ_ID". I copied this table to a temporary backup table using "select * into SOME_TABLE_BKUP from SOME_TABLE". Then I dropped and re-created the original table with the same table structure and primary key constraint. But when I try to insert data from the backup table, "insert into SOME_TABLE select * from SOME_TABLE_BKUP "...
No activity results to display
Show More