On Wed, Apr 10, 2013 at 4:17 PM, John M Bliss <[email protected]> wrote:
> > Because my memory RE: logical operator precedence is often fallible and my > WHERE clauses are often complicated, I almost always use parens, even > when unnecessary. Also, they make "SQL I wrote years ago and haven't looked > at since" easier to understand quickly. For MS SQL, AND takes precedence over OR. Using parentheses usually limits these gotchas. Here's the whole ball of wax re: precedence of operators: http://msdn.microsoft.com/en-us/library/ms190276.aspx ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:355351 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
