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?

The post Populate a SQL Server column with a sequential number not using an identity appeared first on SQLServerCentral.

Click here to read the article