Sqlserver过程WHILE批量新增--代替游标用法

  • binGe博客
  • SqlServer
  • 2024/1/24 16:51:59
  • 人已阅读
简介
 
WHILE EXISTS (SELECT * FROM #HasDaKuanTemp)
        BEGIN
            SELECT TOP 1
                   @NowProjectId = MultipleShopProjectId,
                   @NowDistributorId = DistributorDepartmentBindingId,
                   @NowAmount = Amount
            FROM #HasDaKuanTemp;
            DELETE FROM #HasDaKuanTemp
            WHERE MultipleShopProjectId = @NowProjectId
                  AND DistributorDepartmentBindingId = @NowDistributorId;
            /*
在这里做逻辑处理,插入或更新操作 ...
*/
            UPDATE dbo.BusinessMultipleShopProjectDistributor
            SET Amount = @NowAmount
            WHERE MultipleShopProjectId = @NowProjectId
                  AND DistributorDepartmentBindingId = @NowDistributorId;
        END;

 

文章评论

评论
  • 消灭零回复
Top