Home Forums SQL Server 2005 SQL Server 2005 General Discussion if (select count(*)........) > 0 vs using variable. RE: if (select count(*)........) > 0 vs using variable.

  • December 1, 2015 at 3:36 pm

    #1843350

    I forgot to post the EP when getting the before the IF, here it is.

    It is strange how SQL generate completely different plans for statements that actually do the same thing.