SQL语句给某一列自动编号

 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

 drop table #temp