Populate a SQL Server column with a sequential number not using an identity


I have a database table that has a lot of data already in the table and I need to add a new column to this table to include a new sequential number. In addition to adding the column, I also need to populate the existing records with an incremental counter what options are there to do this?


See Populate SQL Server Column with Sequential Number without identity