sql server 2008 游标循环更新数据

来源：互联网发布：网络借贷平台排行榜编辑：程序博客网时间：2024/05/24 08:34

USE [数据库名称]DECLARE @Audio_location nvarchar(200) Declare @unititemID intdeclare @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; --读取下一行数据            ENDCLOSE My_Cursor; --关闭游标DEALLOCATE My_Cursor; --释放游标GO

0 0