[SQL Server] 循环游标执行-无事务

From: https://blog.csdn.net/weixin_42609389/article/details/126955029

?

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21

begin     declare @a int     declare @temp varchar(50)     set @a=1           declare order_cursor cursor for (select [CMID] from [Warehouse].[MT].[Customers])           open order_cursor           fetch next from order_cursor into @temp                   while @@FETCH_STATUS = 0            begin                        update [Warehouse].[MT].[Customers] set CMCode=@a where [CMID]=@temp             set @a=@a+1             fetch next from order_cursor into @temp           end       close order_cursor      deallocate order_cursor   end go