Query MSSQL Tutorial

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)