Or “Which where runs when?”
There seems to be a lot of misunderstanding about what order conditions within a where clause are executed. In two days I heard from three different places comments about what order conditions must be put in the where clause.
The simple truth is that is doesn’t matter. Let’s look at a very simple example. (Sample code at the end as always)
SELECT * from tblTestWhereOrder WHERE A=1 and B=2 and C is not null