Update Records to Show ID Number

[lah3233]

Please help!

I have a contact database that has basic contact info in it (approx 1200 records).

Now I have found out that I need an ID number.

Does anyone have any ideas on how to populate this field in a quick and easy way without have to run 1200 update statements???

Any help would be greatly appreciated.

The field name is strID.

Thanks!

 

[ClaireHCM]

Alter Table ContactInfo Add ID int Identity(1,1)