SQL 2005+Transact-SQL Operator Precedence
The thirty-seventh part of the SQL Server Programming Fundamentals tutorial brings together information from the previous articles. This article is a simple reference for the precedence of the Transact-SQL (T-SQL) operators.
Operator Precedence
| Unary Bitwise Operators |
|---|
| ~ | | Arithmetic Operators |
|---|
| * / % | | Unary Arithmetic Operators |
|---|
| + - | | Arithmetic / Concatenation Operators |
|---|
| [+ arithmetic] [+ concatenation)] - | | Bitwise Operators |
|---|
| & ^ | | | Comparison Operators |
|---|
| =, >, <, >=, <=, <>, !=, !>, !< | | Logical |
|---|
| NOT AND ALL ANY BETWEEN IN LIKE OR SOME | | Assignment |
|---|
| = |
|