• hodgy (8/4/2008)


    I enjoyed this question (even though the clause is being phased out!) as it was something I wasn't aware of, and it made me go off and research the subject. Now I understand.

    Tom

    Thanks, Tom!

    And my apologies to everyone for the lousy formatting of the replies. All "&&"s were supposed to be replaced by line feeds, but that somehow didn't quite work out as expected. I've sent an email to Steve Jones, asking him to correct this, but given that it's deep night in his time zone, I don't expect this to happen for at least a few hours more. 🙁


    Hugo Kornelis, SQL Server/Data Platform MVP (2006-2016)
    Visit my SQL Server blog: https://sqlserverfast.com/blog/
    SQL Server Execution Plan Reference: https://sqlserverfast.com/epr/