russ_hardie@hotmail.com
Old Hand
Points: 389
More actions
June 30, 2014 at 1:24 am
#150166
WHERE @var = 0 OR NOT EXISTS (SELECT 'x' FROM ...)
Will MS sql evaluate the NOT EXISTS if @var = 0?
http://en.wikipedia.org/wiki/Short-circuit_evaluation
Viewing 0 posts
You must be logged in to reply to this topic. Login to reply