1,
select cast(identity(int,1,1) as int) as 序号,name into #temp from table
select * from #temp2,select * from #temp where 序号=N
select cast(identity(int,1,1) as int) as 序号,name into #temp from table
select * from #temp2,select * from #temp where 序号=N
1:
select newid as 序号,name from test
2:
select name from test where newid=n
alter table test drop column newid