大数据量更新SQL

USE database
Go
/*================================================================================ 
Server:   
DataBase: 
Author:   
Object:   
Date:     
Content:  
================================================================================*/
CREATE PROCEDURE [dbo].[UP_RMA_UpdateCompanyCodeOfRMAMaster]
AS
BEGIN
 SET NOCOUNT ON

 IF NOT EXISTS(
     SELECT TOP 1 1
     FROM dbo.RMAMaster WITH(NOLOCK)
     WHERE CompanyCode IS NULL
     )
 BEGIN
  SELECT 'There is no record with null company code in RMAMaster.' as Result
  RETURN
 END

 DECLARE  @rows int
   ,@row_batch int
   ,@row_count int

 SELECT 
  @rows = 0
    ,@row_batch = 2000
    ,@row_count = @row_batch
 
 WHILE @row_count = @row_batch
 BEGIN

  UPDATE TOP(@row_batch) SVC2005.dbo.RMAMaster
  SET CompanyCode=1003
  WHERE
   CompanyCode IS NULL

  SELECT 
   @row_count = @@ROWCOUNT
     ,@rows = @rows + @row_count
    
  RAISERROR('%d rows.', 10, 1, @rows) WITH NOWAIT
  WAITFOR DELAY '00:00:10'
 END

 SELECT CAST(@rows AS VARCHAR(10)) + ' records are processed.' as Result

END