本文深入解析SQL语句中的条件判断及逻辑运算应用，通过具体实例展示如何利用逻辑运算符实现复杂查询逻辑，提升数据库操作效率。
IF(
(@FCCPROCESSSTATUS <>0 AND NOT(@FCCPROCESSSTATUS = 2 AND ISNULL(@DCCFLOWVERSION,0) = 2))
--(@FCCPROCESSSTATUS <>0 AND NOT(@FCCPROCESSSTATUS = 2 AND @DCCFLOWVERSION = 2))
OR (@FOREIGNAMOUNT IS NOT NULL)
)
BEGIN
Print 'DCCFlow : ' + cast( @DCCFLOWVERSION as varchar(10)) + '!!'
END
ELSE
BEGIN
Print 'DCCFlow : nothing '
END
NOTE: when @DCCFLOWVERSION is nothing(not null) , the first branch will not be reached!!!!
so the fix is the line highlighted in RED.
扫一扫
1万+
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
