I kind of figured that was what it was doing, or at least hoped, however I could never find any docs on what it was really doing.
But since I could never get a perf increase or decrease I could only assume, and this thread seemed like the perfect place and oportunity to ask that question.
I would imagine depending on the database there is an option to override the behavior but I have never ran into that as well. A lot of programming languages are set up this way.
For Example in C#
say int he example below Both Method returned true
if(DoMethod1() || DoMethod2())
In that example Method 1 would fire and eveluate to true so method 2 would never fire.
if(DoMethod1() | DoMethod2())
Would actually still force both methods to fire then evaluate to true.
I just never knew if SQL did that or not.
Keep Up with TechRepublic