如何自动获得序号－－－－－－－急

[Kstar]

Table1
a b(datetime)
1 2001-01-01
2 2001-01-03
Table2
a b(datetime)
1 2001-01-02
2 2001-01-04
通过union
获得结果
新字段 a b
1 1 2001-01-01
2 2 2001-01-03
3 1 2001-01-02
4 2 2001-01-04

[pengdali]

select identity(int,1,1) id,* into #a from (select a,b from table1 union all select a,b from table2) tem
select * from #a

[zhuliangjun0]

建立一个有自增列的表table3
create table3 (ID int identity not Null,a int ,b datetime)
insert into table3 select * from table1 union all select * from table2

[Kstar]

谢了，不过我不想要临时表，不能只是显示在内存中么

[Kstar]

象视图一那样不行么

[zhbname]

很難.

[Kstar]

up

[zjcxc]

没临时表基本上不可能.

[pengdali]

declare @table3 table(ID int identity not Null,a int ,b datetime)

insert @table3 select * from table1 union all select * from table2

select * from @table3