什么意思?1:
Select identity(int,1,1) as iid,* from table1
Select * from #tmp2:如果table1有主键,比如 keyField
Select (Select sum(1) from table1 where keyField <= a.keyField) as iid,* from table1 a
Select identity(int,1,1) as iid,* from table1
Select * from #tmp2:如果table1有主键,比如 keyField
Select (Select sum(1) from table1 where keyField <= a.keyField) as iid,* from table1 a
Select identity(int,1,1) as iid,* from table1
Select * from #tmp2:如果table1有主键,比如 keyField
Select (Select sum(1) from table1 where keyField <= a.keyField) as iid,* from table1 a
create table 表(id int identity(1,1),name varchar(100))
insert 表 values('J9988')
insert 表 values('CSDNM')
select * from 表
drop table 表