-- SQL Server 2005 query SELECT 字段, ROW_NUMBER() OVER(ORDER BY 字段) AS rownum FROM 表 -- SQL Server 2000 query SELECT 字段 (SELECT COUNT(*) FROM 表 AS S2 WHERE S2.字段 <= S1.字段) AS rownum FROM 表 AS S1
select identity(int,1,1) as id,单位名,密码 into # from 表 select * from # drop table #
SELECT 字段,
ROW_NUMBER() OVER(ORDER BY 字段) AS rownum
FROM 表
-- SQL Server 2000 query
SELECT 字段
(SELECT COUNT(*)
FROM 表 AS S2
WHERE S2.字段 <= S1.字段) AS rownum
FROM 表 AS S1
select * from #
drop table #