如果楼主的表中有IDENTITY标识列的话(例如id),可以这样: create view viewTest as select newid = (select count(*) from table where id >= a.id ), * from table a order by newid GO select * from viewTest order by newid
抱歉,更正一下(在上面的视图定义中去掉order by newid): create view viewTest as select newid = (select count(*) from table where id >= a.id ), * from table a ----去掉order by newid GO select * from viewTest order by newid
2005可以用row_number了select id=row_number() over(order by id), * from 表
create view viewTest
as
select newid = (select count(*) from table where id >= a.id ), *
from table a order by newid
GO
select * from viewTest order by newid
create view viewTest
as
select newid = (select count(*) from table where id >= a.id ), *
from table a ----去掉order by newid
GO
select * from viewTest order by newid