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.
Eric_Gagne
SSCrazy
Points: 2062
More actions
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.