Update query problem

[rajesh876]

Hello,

I am trying update the Uniqueidentifier column through all the tables in my database.When i executed the following query,I am getting an error that field cannot be updated.
Please tell me how should i update the Uniqueindentifier column.Datatype of this column is autonumber.

UPDATE PatientInfo SET UniqueIdentifier=UniqueIdentifier+476 where UniqueIdentifier>539;

Thanks,

 

[boblarson]

Why are you trying to update an autonumber?

 

[rajesh876]

I did in the other way.Thanks for your reply though.I wanted to update before because we have 2 databases of same kind with some simliar data.So i have to change the autonumbers in one database.i.e reason i asked this question.Thanks,