sql server 2008 游标循环更新数据

USE [数据库名称]

DECLARE @Audio_location nvarchar(200) 
Declare @unititemID int
declare @newaudio nvarchar(200)

DECLARE My_Cursor CURSOR --定义游标
FOR (select Audio_location,UnititemID  from [架构名].[表名]) --查出需要的集合放到游标中
OPEN My_Cursor; --打开游标
FETCH NEXT FROM My_Cursor INTO @Audio_location,@unititemID; --读取第一行数据(将MemberAccount表中的UserId放到@UserId变量中)
WHILE @@FETCH_STATUS = 0
    BEGIN
    
    set @newaudio=''
    
   
    
    
    select @newaudio+=a from LCMS.func_split(@Audio_location,'_') where idx=1
    

     select @newaudio+='_'+cast(@unititemID as varchar(100))
  
     
    select @newaudio+='_'+a from LCMS.func_split(@Audio_location,'_') where idx=3
    
    
   --select @Audio_location ,@newaudio,@unititemID
    
     UPDATE [架构名].[表名] SET Audio_location = @newaudio  WHERE CURRENT OF My_Cursor; --更新
       
        FETCH NEXT FROM My_Cursor INTO @Audio_location,@unititemID; --读取下一行数据
        
    END
CLOSE My_Cursor; --关闭游标
DEALLOCATE My_Cursor; --释放游标
GO