sqlserver修改某个表重复ID

DECLARE @logid VARCHAR(16);
DECLARE tempCursor CURSOR
FOR ( select logid from SYS_FLOW_CALLBACK_LOG group by logid having count(logid)=2 );								--创建游标，并定义游标所指向的集合   

OPEN tempCursor;								--打开游标  
FETCH NEXT FROM tempCursor INTO @logid;			--游标读取下一个数据  
WHILE @@fetch_status = 0                        --游标读取下一个数据的状态，0表示读取成功  
    BEGIN  
		
				EXEC('update top(1) SYS_FLOW_CALLBACK_LOG set logid=replace(logid,''L'',''LB'') where logid='''+@logid+'''   ' )
				
        FETCH NEXT FROM tempCursor INTO @logid;    --继续用游标读取下一个数据  
    END  
CLOSE tempCursor;							
DEALLOCATE tempCursor;