declare @a table (a int identity(1,1),b int)
insert @a(b)
select 23 union all
select 889 union all
select 345 union all
select 2 union all
select 100select a=right(1000+a,3),b from @a
insert @a(b)
select 23 union all
select 889 union all
select 345 union all
select 2 union all
select 100select a=right(1000+a,3),b from @a
set @I = 1
update table set seqno=right(1000+@i,3),@I = @i +1