396028 0
396028 0
396028 0
214014 0
396028 0Uid SortIndex------------------要把这个表更新为396028 1
396028 2
396028 3
214014 1
396028 4-
就是uid相同的SortIndex递增
396028 0
396028 0
214014 0
396028 0Uid SortIndex------------------要把这个表更新为396028 1
396028 2
396028 3
214014 1
396028 4-
就是uid相同的SortIndex递增
go
create table [tb]([Uid] int,[SortIndex] int)
insert [tb]
select 396028,0 union all
select 396028,0 union all
select 396028,0 union all
select 214014,0 union all
select 396028,0
goalter table tb add tmpid int identity(1,1);
goupdate t
set SortIndex=(select count(1)+1 from tb where uid=t.uid and tmpid<t.tmpid)
from tb t
goalter table tb drop column tmpid;
goselect * from tb
/**
Uid SortIndex
----------- -----------
396028 1
396028 2
396028 3
214014 1
396028 4(5 行受影响)
**/