updating a primary key

[zybernau]

hi everyone,

i am forced to update a field[ID] which is one of the primary keys in a table

the update will be like a sorta swap between the ids inside the table

my solution is ,
doing a double update, first updating with dummy number then replacing the dummy with original one

But i am looking for a solution which is more professional ,

note, i cannot do any type of data structure / DB Schema change in back end

[r035198x]

That is the only way.
P.S How is this related to .NET?

[zybernau]

That is the only way.
P.S How is this related to .NET?

tnx,

i'm developing thro .Net, so i thought it was appropriate, if not sorry.