34,590
社区成员
发帖
与我相关
我的任务
分享请发表友善的回复…
发表回复
zjcxc 元老 2006-08-03
- 打赏
- 举报
2005可以用row_number了
select id=row_number() over(order by id), * from 表
select id=row_number() over(order by id), * from 表
zjcxc 元老 2006-08-03
- 打赏
- 举报
2000可以利用主键生成这样的编号, 参考2楼的
ReViSion 2006-08-03
- 打赏
- 举报
如果行的话，分页就不用那么麻烦啦
ReViSion 2006-08-03
- 打赏
- 举报
不行
xxwnet 2006-08-03
- 打赏
- 举报
不对，我a.id就有重复的
xyxfly 2006-08-03
- 打赏
- 举报
恩，类似于插入ID到临时表
hellowork 2006-08-03
- 打赏
- 举报
抱歉,更正一下(在上面的视图定义中去掉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
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
hellowork 2006-08-03
- 打赏
- 举报
如果楼主的表中有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
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
