sql对数据的循环操作

 select ROW_NUMBER() OVER(ORDER BY rid)   ROWNU ,* into #skunoList from [Mst_SKU] where [SKUNo] like '%102-%'
 
DECLARE @iLoop int,--某一行的记录
        @MaxID int--总行数
 select  @MaxID =(select COUNT(skuno) from #skunoList);
 select @iLoop=1;

 while  @iLoop<=@MaxID       
 begin   --111获取某条记录的生产量开始 qty的值
	   DECLARE @RID VARCHAR(50)
	   select @RID=(select rid from #skunoList where ROWNU=@iLoop )
	   update [Mst_SKU] set [PriceTagBarCode]='100102'+@iLoop where RID=@RID
	   select @iLoop=@iLoop+1;
end