The problem with the above tip is that it involves the modification of the underlying table schema. A better solution would be to run the traversal over the designed table schema, utilising the primary key value as a traversal key.
The following tip requires a sortable primary key.
if object_id('dbo.SomeTable', 'U') is not null
drop table dbo.SomeTable;
create table dbo.SomeTable
id int identity(1, 1) not null primary key - Used as Traversal Key
,Value int not null
declare @id int = 0;
while exists (select top 1 id from SomeTable where id > @id)
declare @value int;
select top 1
@value = value
,@id = id
where id > @Id
order by id;
The benefit of this means you are no longer modifying the underlying schema of the table, and because of the sort operation, you can use any field as the traversal key.
The only requirement is that the traversal key must be unique.
Simple Table Population Code
insert into SomeTable (Value)