简单查询处理

[广州人]

我有一个语句select ID,Name,Year from tEmp

返回的结果是
zhangsan,张三，23
lisi,李四，24

但是我希望的结果是
1,zhangsan,张三，23
2,lisi,李四，24

怎么写呢？

[SQL77]

select IDD=IDENTITY(INT,1,1), ID,Name,Year INTO #T from tEmp
SELECT * FROM #t

[SQL77]

select IDD=IDENTITY(INT,1,1), ID,Name,Year INTO #T from tEmp
SELECT * FROM #t

[广州人]

不要临时表，存储过程，麻烦各位了。。

[快溜]

select row_number() over(order by getdate()),ID,Name,Year from tEmp

[mycodeis0000]

select fnewId=row_number() over(order by fid),fid,fname,fyear from tEmp

[jmx123456789]

--05以上
select fnewId=row_number() over(order by fid),fid,fname,fyear from tEmp