sql server 根据行号更新某列的数据(可以根据其他列做筛选)
文章目录
执行如下存储过程:
declare @scp_code varchar(50);
declare @id INT;
DECLARE cur CURSOR FOR --查找s_link 有重复的路径
select cp_code from cp_sick
GROUP BY cp_code, s_link HAVING count(s_link) > 1;
OPEN cur
fetch next from cur into @scp_code
while(@@fetch_status=0)
begin
print(@scp_code)
set @id=0
update cp_sick SET s_link=@id,@id=@id+1 WHERE cp_code = @scp_code;
fetch next from cur into @scp_code
end
close cur
DEALLOCATE cur
评论
登录后参与技术讨论,分享你的经验与见解。
登录 / 注册暂无评论