>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?

Use a GUID instead of an int.