SQL Server Operators

on

Arithmetic Operator

Operator
Meaning
+ (Add)
Addition
- (Subtract)
Subtraction
* (Multiply)
Multiplication
/ (Divide)
Division
% (Modulo)
Returns the integer remainder of a division. For example, 12 % 5 = 2 because the remainder of 12 divided by 5 is 2.

Logical Operator

Operator
Meaning
ALL
TRUE if all of a set of comparisons are TRUE.
AND
TRUE if both Boolean expressions are TRUE.
ANY
TRUE if any one of a set of comparisons are TRUE.
BETWEEN
TRUE if the operand is within a range.
EXISTS
TRUE if a subquery contains any rows.
IN
TRUE if the operand is equal to one of a list of expressions.
LIKE
TRUE if the operand matches a pattern.
NOT
Reverses the value of any other Boolean operator.
OR
TRUE if either Boolean expression is TRUE.
SOME
TRUE if some of a set of comparisons are TRUE.

Bitwise Operators

  & (Bitwise AND)
  &= (Bitwise AND Assignment)
  | (Bitwise OR)
  |= (Bitwise OR Assignment)
  ^ (Bitwise Exclusive OR)
  ^= (Bitwise Exclusive OR Assignment)
  ~ (Bitwise NOT)

Comparison Operators

Operator
Meaning
= (Equals)
Equal to
> (Greater Than)
Greater than
< (Less Than)
Less than
>= (Greater Than or Equal To)
Greater than or equal to
<= (Less Than or Equal To)
Less than or equal to
<> (Not Equal To)
Not equal to
!= (Not Equal To)
Not equal to (not ISO standard)
!< (Not Less Than)
Not less than (not ISO standard)
!> (Not Greater Than)
Not greater than (not ISO standard)
 

Compound operators

Operator
Link to more information
Action
+=
+= (Add Assignment) (Transact-SQL)
Adds some amount to the original value and sets the original value to the result.
-=
-= (Subtract Assignment) (Transact-SQL)
Subtracts some amount from the original value and sets the original value to the result.
*=
*= (Multiply Assignment) (Transact-SQL)
Multiplies by an amount and sets the original value to the result.
/=
(Divide Assignment) (Transact-SQL)
Divides by an amount and sets the original value to the result.
%=
Modulus Assignment (Transact-SQL)
Divides by an amount and sets the original value to the modulo.
&=
&= (Bitwise AND Assignment) (Transact-SQL)
Performs a bitwise AND and sets the original value to the result.
^=
^= (Bitwise Exclusive OR Assignment) (Transact-SQL)
Performs a bitwise exclusive OR and sets the original value to the result.
|=
|= (Bitwise OR Assignment) (Transact-SQL)
Performs a bitwise OR and sets the original value to the result.

Unary Operators

Operator
Meaning
+ (Positive)
Numeric value is positive.
- (Negative)
Numeric value is negative.
~ (Bitwise NOT)
Returns the ones complement of the number.

Assignment Operator

= is used to assign value from right side (variable, constant) to left variable

String concatenation operators