select * into #temp from(
select 'a' as coll,' ' id
union all
select 'b',' ' id
union all
select 'c',' ' id
union all
select 'd',' ' id
)a
declare @i int=0
update #temp set id=id+@i,@i=@i+1
select * from #temp
select * into #temp from( select 'a' as coll,' ' id union all select 'b',' ' id union all select 'c',' ' id union all select 'd',' ' id )a declare @i int=0 update #temp set