update xuanshouInfo set qianhao =sort_index ,ZuMax =2 from XuanshouInfo a left join (select ROW_NUMBER() over(order by id) sort_index,Id from XuanshouInfo where Jibie = '男自55kg') b on a.id = b.id where a.jibie = '男自55kg'
更新查询后链表的数据
update xuanshouInfo set qianhao =sort_index ,ZuMax =2 from XuanshouInfo a left join (select ROW_NUMBER() over(order by id) sort_index,Id from XuanshouInfo where Jibie = '男自55kg') b on a.id = b.id where a.jibie = '男自55kg'
更新查询后链表的数据