有一表"table1"如下
id daa fid
1 561
2 564
3 451
4 454我想在“fid”列中从3开始,自增+1的序号填充“fid”列。结果如下:id daa fid
1 561 3
2 564 4
3 451 5
4 454 6
id daa fid
1 561
2 564
3 451
4 454我想在“fid”列中从3开始,自增+1的序号填充“fid”列。结果如下:id daa fid
1 561 3
2 564 4
3 451 5
4 454 6
如果id不连续;with cte as
(
select idx=row_number() over(order by id ),* from tb
)
update cte set fid=idx+2;
1.建立一个试图
2.计算列
3.触发器更新一次:
update tb set fid = id + 2
update tb set fid = id + 2
id int identity(1,1),
name varchar(20)
)
GO
insert into tb
select '2' union all
select '3' union all
select '4'select id,name,ROW = ROW_NUMBER() over(order by id asc) + 2
from tb