求一条SQL语句！

[mailreboot]

现在有一张表如：STUDENT,其数据如下：

USER_ID NAME AGE
2007414 王二 19
2007401 张三 21
2004121 李四 25
2015451 张飞 18
2015454 朱二 17

我想用SELECT语句得到下面的结果，该如何写？

ID USER_ID NAME AGE
1 2007414 王二 19
2 2007401 张三 21
3 2004121 李四 25
4 2015451 张飞 18
5 2015454 朱二 17

做SELECT的时候新增一列ID,ID列的值是自动增长的，该如何写？

[xeqtr1982]

select [id]=identity(int,1,1),* into # from STUDENT
select * from #
drop table #

[billpu]

select *,identity(int,1,1) as id from student

[邪V风]

alter table [表名] add column 字段名 字段类型

[itblog]

select ID=identity(int,1,1),* into # from STUDENT
select * from #

[billpu]

select *,identity(int,1,1) as id into newtable from student

[OracleRoob]

--用临时表
select identity(int,1,1) as ID,*
into #tp
from STUDENT

select * from #tp

drop table #tp

[brooks105]

select identity(int,1,1) as ID,* from STUDENT

[wwh999]

--得到结果集
select [id]=identity(int,1,1),* from STUDENT

--得到结果集,并放到一新表中,假定为newTb
select [id]=identity(int,1,1),* into newTb from STUDENT

[wwh999]

xeqtr1982(HaN)是一楼啊....恭喜恭喜!

[paoluo]

Select的時候是不能加入自增列的，除非借用臨時表，然後從臨時表中查詢。

如果你的USER_ID是不會重復的話，可以借用一下生成類似自增列的一列.
Select
ID=(Select Count(*) From STUDENT Where [USER_ID]<=A.[USER_ID]),
*
From STUDENT A

[paoluo]

billpu(加勒比小飞猪) ( ) 信誉：100 2006-06-08 16:57:00 得分: 0


select *,identity(int,1,1) as id from student


brooks105(羔羊) ( ) 信誉：100 2006-06-08 16:59:00 得分: 0


select identity(int,1,1) as ID,* from STUDENT

wwh999(印钞机的卖 V2.0...发梦ing) ( ) 信誉：100 2006-06-08 17:00:00 得分: 0


--得到结果集
select [id]=identity(int,1,1),* from STUDENT

------------------------------------------------------
這幾種寫法都有錯誤。

[quanyi]

select identity(int,1,1) as ID,*
into #tp
from STUDENT

select * from #tp

drop table #tp

[软猫克鲁]

SELECT
ROW_NUMBER() OVER () AS NUM
, TB.*
FROM TB
;

[软猫克鲁]

MS-SQL Server 不知道行不行。Orcale,DB2可以。