有关identity

[awjx]

select identity(int,1,1)as mid,* into #temp from table1
where ID=@ID

但提示ID已经有identity属性，也就是说上面的语句存在问题，请问怎么办呢？
这段时间我发帖比较多，大力兄是这样回答我的
select IDENTITY(int, 1,1) AS ID_Num,* into #temp from 表
select * from #temp where ID_Num between 10 and 20


所以我想大力兄或各位高手讲讲，
对于identity我略知一二，但碰到上述问题我不知怎办？

[pengdali]

lect IDENTITY(int, 1,1) AS ID_Num,cast(你原来有的id as int) id,其他列 into #temp from 表
select * from #temp where ID_Num between 10 and 20

[pengdali]

select IDENTITY(int, 1,1) AS ID_Num,cast(你原来有的id as int) id,其他列 into #temp from 表
select * from #temp where ID_Num between 10 and 20