可否使select语句多加一列:0,1,2,3,4,5...

[hainang1234]

可否使select语句多加一列:0,1,2,3,4,5...
加的这列从0开始一直递增。

原始需求：给t1加数据，数据从t2中来，t1中的某一列为顺序列，每加一些数据，这些数据的顺序都是0,1,2

谢谢。

[子陌红尘]

用临时表：

select identity(int,0,1) as rowid,* into #t from t2
insert into t1 select * from #t
drop table #t

[点点星灯]

select identity(int,0,1) as 'ID',a.f2, a.f3, ... into #t from tablename

select * from #t

[-狙击手-]

select rowid = identity(int,1,1) ,a.f2, a.f3, ... into #t from t2 where ...

insert into s1 select * from #t

drop table #t

[-狙击手-]

select rowid = identity(int,0,1) ,a.f2, a.f3, ... into #t from t2 where ...

insert into s1 select * from #t

drop table #t

看错了，要从0

[老本]

Oracle: Rownum.
SQL Server 中没有直接的伪列可用。

[hainang1234]

多谢各位大侠！