SQL Server AND和OR的优先级 [英] SQL Server ANDs and ORs precedence
本文介绍了SQL Server AND和OR的优先级的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！
问题描述
我正在调试一些代码，并遇到了这个问题.有人可以根据SQL Server的顺序在该语句周围添加括号来帮助我.是我一个人，还是编码不好?
I'm debugging some code and came across this. Could someone help me by putting parens around this statement according to SQL Server ordering. Is it just me, or is this bad coding?
WHERE
T1.C1 = @VAR1 AND T1.C2 = @VAR2 AND T1.C3 NOT IN(@VAR3)
OR T2.C1 = @VAR2 OR T3.C1 = @VAR2
推荐答案
按原样，它将像
WHERE
(T1.C1 = @VAR1 AND T1.C2 = @VAR2 AND T1.C3 NOT IN(@VAR3))
OR
(T2.C1 = @VAR2)
OR
(T3.C1 = @VAR2)
这篇关于SQL Server AND和OR的优先级的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
查看全文
