T_SQL利用游标遍历表记录，更新每条记录ID值

利用游标遍历表，更新表记录

declare  @Id bigint

declare @count int

declare @eventIDvarchar(50)

 

set @Id = 4294967297

 

 

declare my_Cursorcursor local for

 

select EventCodefrom eventRule

 

open my_Cursor

 

while @@FETCH_STATUS= 0

begin

 fetch next from my_Cursor into @eventID

 update EventRule set ID = @Id where EventCode= @eventID

 

 set @Id = @Id + 1

end

 

close my_Cursor

deallocate my_Cursor