BlackWaspTM

This web site uses cookies. By using the site you accept the cookie policy.This message is for compliance with the UK ICO law.

SQL Server
SQLCastConvert.aspx

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
=
29 September 2009