Sqlserver过程WHILE批量新增--代替游标用法
- 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;
上一篇:SQLServer 查询数据重复
文章评论
- 消灭零回复