Home Forums Article Discussions Article Discussions by Author Discuss content posted by Gianluca Sartori Understanding T-SQL Expression Short-Circuiting RE: Understanding T-SQL Expression Short-Circuiting
spaghettidba
SSC Guru
Points: 105732
More actions
December 30, 2010 at 2:30 pm
#1267956
sknox (12/30/2010)So you have to evaluate both sides of the XOR.
sknox (12/30/2010)
So you have to evaluate both sides of the XOR.
When first name is null and middle name is not null, the second part of the or expression does not get evaluated.
-- Gianluca Sartori