为什么这个sql语句有错
select ID_Num from (SELECT IDENTITY(int, 1,1) AS ID_Num ,test INTO #
FROM test order by age desc)

[解决办法]
SELECT IDENTITY(int, 1,1) AS ID_Num ,id INTO # FROM test
-----------------------------------
这是个创建表的语句,而不是查询语句,不会返回查询结果,不能作为子查询.
楼主应该将语句拆开:
SELECT IDENTITY(int, 1,1) AS ID_Num ,id INTO # FROM test order by age desc
select ID_Num from # where id =@id


[解决办法]
select ID_Num from (SELECT IDENTITY(int, 1,1) AS ID_Num ,test INTO #
FROM test order by age desc)

生成表不能放在查询里:
SELECT IDENTITY(int, 1,1) AS ID_Num ,test INTO #
FROM test order by age desc

--再查询
select ID_Num from #