2023年8月3日发(作者：)

sqlupdate三⽬运算的使⽤⾸先先看⼀下三⽬运算在sql 中怎么使⽤的

SELECT ( CASE WHEN STATUS = 1 THEN 'yes' ELSE 'no' END ) AS STATUSFROM t_template_paper这是查询的语句块

修改中使⽤的使⽤如下--修改逾期 1-3天的UPDATE T_LoansSET OverdueTime = GETDATE() , OverdueDay = (CASE WHEN DATEDIFF(DAY,LastShouldReturnTime ,GETDATE()) >3 THEN --再次验证 是否第⼀次 防⽌重复累加 第⼀次⼤于的现象做的验证判断 下⾯的逻辑都是如此 (CASE WHEN IsOverdue = 0 THEN 3 ELSE OverdueDay END)

ELSE DATEDIFF(DAY,LastShouldReturnTime ,GETDATE()) END ), OverdueInterest = OverdueInterest + ( LoanAmount * @OverdueCost / 100 ) * (CASE WHEN DATEDIFF(DAY,LastShouldReturnTime ,GETDATE()) >3 THEN

--再次验证 是否第⼀次 防⽌重复累加 (CASE WHEN IsOverdue = 0 THEN 3 ELSE 0 END) ELSE (DATEDIFF(DAY,LastShouldReturnTime ,GETDATE()) - OverdueDay) END ), IsOverdue = 1WHERE Status = 3 AND DATEDIFF(DAY,LastShouldReturnTime ,GETDATE()) >0 AND PlatformID=@PlatformId;⽤法嵌套与查询相同

2023年8月3日发(作者：)

sqlupdate三⽬运算的使⽤⾸先先看⼀下三⽬运算在sql 中怎么使⽤的

SELECT ( CASE WHEN STATUS = 1 THEN 'yes' ELSE 'no' END ) AS STATUSFROM t_template_paper这是查询的语句块

修改中使⽤的使⽤如下--修改逾期 1-3天的UPDATE T_LoansSET OverdueTime = GETDATE() , OverdueDay = (CASE WHEN DATEDIFF(DAY,LastShouldReturnTime ,GETDATE()) >3 THEN --再次验证 是否第⼀次 防⽌重复累加 第⼀次⼤于的现象做的验证判断 下⾯的逻辑都是如此 (CASE WHEN IsOverdue = 0 THEN 3 ELSE OverdueDay END)

ELSE DATEDIFF(DAY,LastShouldReturnTime ,GETDATE()) END ), OverdueInterest = OverdueInterest + ( LoanAmount * @OverdueCost / 100 ) * (CASE WHEN DATEDIFF(DAY,LastShouldReturnTime ,GETDATE()) >3 THEN

--再次验证 是否第⼀次 防⽌重复累加 (CASE WHEN IsOverdue = 0 THEN 3 ELSE 0 END) ELSE (DATEDIFF(DAY,LastShouldReturnTime ,GETDATE()) - OverdueDay) END ), IsOverdue = 1WHERE Status = 3 AND DATEDIFF(DAY,LastShouldReturnTime ,GETDATE()) >0 AND PlatformID=@PlatformId;⽤法嵌套与查询相同