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

  • March 3, 2011 at 12:56 pm

    #1294279

    This post seems to recommend CASE as a way to get deterministic short circuiting in T-SQL. Unfortunately, even CASE does not always provide deterministic order of evaluation with short circuiting. See http://bartduncansql.wordpress.com/2011/03/03/dont-depend-on-expression-short-circuiting-in-t-sql-not-even-with-case/[/url].