select seq=identity(int,1,1),* into #t from tablename select * from #t 如果表有主键(keycol),可以不用临时表 select seq=(select sum(1) from tablename where keycol<=a.keycol),* from tablename a
同意2 楼,1楼的不对,没有into 表的话,不能直接在select 中用identity 而2 楼的第二个方法,生成的seq是按主键顺序生成的(数据量大时,效率不是太好),这个主键,可以是表中任意值不重复的列都可以select seq=(select sum(1) from tablename where keycol<=a.keycol),* from tablename a
select identity(int,1,1) seq,fieldl,field2 into #aa from tablenameselect * from #aa order by seq
select identity(int,1,1) seq,fieldl,field2 into #t from tablename select * from #t
select * from #t
如果表有主键(keycol),可以不用临时表
select seq=(select sum(1) from tablename where keycol<=a.keycol),* from tablename a
而2 楼的第二个方法,生成的seq是按主键顺序生成的(数据量大时,效率不是太好),这个主键,可以是表中任意值不重复的列都可以select seq=(select sum(1) from tablename where keycol<=a.keycol),* from tablename a
select * from #t