How to insert row with explicit primary key
Posted on 2010-11-29
I have a small sql ce database and I want to restore some rows from an sql script. Everything works fine, except the newly added rows are given new primary keys, even though I explicitly state them in the insert statement. I can export a row with ID = 8 but when I insert it again, I get's a new ID, how can I insert a new row and force the database to give that row a specific ID ??? Otherwise I can't restore the database and give the imported rows the correct IDs.