Mega Code Archive

 

Categories / MSSQL Tutorial / Query

 

Operator Precedence

Precedence      Operator(s) 1               0(parentheses) 2               + (Positive), - (Negative), ~ (Bitwise NOT) 3               * (Multiply), / (Divide), % (Modulo) 4               + (Add), (+ Concatenate), - (Subtract) 5               =, >, <, >=, <=, <>, !=, !>, !< (Comparison operators) 6               ^ (Bitwise XOR), & (Bitwise AND), | (Bitwise OR) 7               NOT 8               AND 9               ALL, ANY, BETWEEN, IN, LIKE, OR, SOME 10              = (Assignment)