• I'm wrong here but this is not correct question;

    1 & 2 are the same ... with same condition! So the correct answer is 2 but the 1 is the same everything ... too stupid!

    3 is different!

    also with three options I do not have valid parse for T-SQL code!

    how can you explain it!?

    :hehe::w00t: :P:P:P:P:P

    ============================================================
    SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
    http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]