select id= identity(int,1,1) , name into temp from table select * from temp
select identity(int,1,1) as xuhao,name into #t from table select * from #t;
select id= identity(int,1,1) , name into #t from table select * from #t
这个不需要临时表 SELECT * , xuhao=(SELECT COUNT(DISTINCT name) FROM tb WHERE name >= a.name) FROM tb a ORDER BY xuhao
如果不用臨時表的話 select id=(select count(*) from t where name<=a.name),name from t a
select id= identity(int,1,1) , name into temp from table select * from temp 如果是2005 示例: Select SalesOrderID, orderDate, ROW_NUMBER() OVER (order by orderDate)as RowNumber FROM Sales.SalesOrderHeader
--如果name有序且不重復 select ID = (Select Count(name) from 表 Where name <= A.name), name from 表 A--否則,借用臨時表Select ID = Identity(Int, 1, 1), name Into #T from 表 Select * From #T Drop Table #T
select 序号列= identity(int,1,1) , 字段列表 into #临时表 from 表名 select * from #临时表
select * from temp
select * from #t;
select * from #t
SELECT * , xuhao=(SELECT COUNT(DISTINCT name) FROM tb WHERE name >= a.name)
FROM tb a
ORDER BY xuhao
select id=(select count(*) from t where name<=a.name),name from t a
select * from temp
如果是2005
示例:
Select SalesOrderID, orderDate,
ROW_NUMBER() OVER (order by orderDate)as RowNumber
FROM Sales.SalesOrderHeader
select ID = (Select Count(name) from 表 Where name <= A.name), name from 表 A--否則,借用臨時表Select ID = Identity(Int, 1, 1), name Into #T from 表
Select * From #T
Drop Table #T
select * from #临时表