Question: do sql case statements short circuit?
Answer: SQL Server usually does short-circuit evaluation for CASE statements (SQLFiddle): --Does not fail on the divide by zero. ... SELECT CASE WHEN 1/1 = 99 THEN 'Case 1' WHEN 2/0 = 99 THEN 'Case 2' END; There are however several types of statements that as of SQL Server 2012 do not correctly short-circuit.