This is MySQL. Sent from my iPhone 4S.
On Apr 10, 2013, at 5:41 PM, Stephen Hait <[email protected]> wrote: > > 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:355352 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
