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

T_SQL利用游标遍历表记录，更新每条记录ID值,布布扣,bubuko.com

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

原文：http://blog.csdn.net/seamonkey/article/details/24356953