使用存储过程为海量数据库表更新字段

CREATE PROCEDURE [dbo].[updateUUID] AS
declare @uuid as varchar(50)
declare @id as varchar(50)
declare service_gj_cursor cursor for select 编号 from [main] where uuid is null for update
open service_gj_cursor

-- 根据cursor中的字段，在fetch的时候进行into到具体的变量中！
 fetch next from service_gj_cursor into @uuid
begin
while @@fetch_status=0
    begin  
                           update [main] set uuid=newID() where 编号=@uuid

--再写一次，为了可以执行循环体
       fetch next from service_gj_cursor into @uuid
                          end
end
close service_gj_cursor
deallocate service_gj_cursor
GO