>>>I have imported an Excel file into a SQL table. There is nothing unique in the data, so I want to add an Id column and populate it with 1 to the record count.
>>>
>>>How do I do this in SQL 2005?
>>
>>ALTER TABLE and add int column with IDENTITY attribute.
>
>Perfect! Thanks Sergey!
I thought exactly the same, actually. Just didn't have time to answer right away.
BTW, did you solve your other problem already?
If it's not broken, fix it until it is.
My Blog