SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Fun with Operator Precedence

Let’s have some fun with operator precedence today. Specifically, logical operator precedence. Specifically, how is it evaluated when your where clause says “WHERE This AND That OR Something AND that”, without any clarifying parenthesis? Let’s play around with this. The simplest test scenario is a SELECT 1. If I get a 1 back, that means my WHERE clause evaluated … Continue reading Fun with Operator Precedence

Comments

Leave a comment on the original post [www.midnightdba.com, opens in a new window]

Loading comments...