select id=identity(int,1,1) ,* into #t from tb

------解决方案--------------------

探讨

SQL code
select id=identity(int,1,1) ,* into #t from tb


------解决方案--------------------

--sql 2000

select t.* , px = (select count(1) from tb where col < t.col) + 1 from tb t

--sql 2005

select t.* , px = row_number() over(order by col) from tb t

------解决方案--------------------

探讨

是在视图里，视图上不能这样用