--
> 测试数据：[tb]
if
object_id
(
'
[tb]
'
)
is
not
null
drop
table
[
tb
]
go
create
table
[
tb
]
(
[
id
]
int
,
[
lx
]
int
)
insert
[
tb
]
select
29
,
2
union
all
select
30
,
3
union
all
select
31
,
2
union
all
select
32
,
3
union
all
select
33
,
5
SQL 2000
select
identity
(
int
,
1
,
1
)
as
row_number,id, lx
into
#
temp
from
tb ;
select
*
from
#
temp
SQL2005+
select
row_number()
over
(
order
by
id)
as
row_number,id, lx
from
tb
