Operators in SQL Server

In SQL, operator is a symbol which is used to specify a particular action that is performed on one or more expressions. Generally, we will use these operators in SQL statements to perform a logical or arithmetic or comparison operations. 

 

In SQL we have a different type of operators available, those are 

 

SQL Arithmetic Operators

In SQL, arithmetic operators are useful to perform multiple operations like addition ( ), subtraction (-), division (/), multiply (*), modulo (%) on SQL statements.

 

To know more about arithmetic operators, check this SQL Arithmetic Operators with Examples.

SQL Logical Operators

In SQL, logical operators are useful to perform multiple operations like checking SQL statements based on some conditions like AND, OR, EXISTS, BETWEEN, etc… and comparison of multiple values in SQL statements.

 

To know more about logical operators, check this SQL Logical Operators with Examples.

SQL Assignment Operators

In SQL, assignment operators are used to assign required values to variables. In assignment operators we have only one equal (=) operator available.

SQL Comparison Operators

In SQL, comparison operators are useful to compare multiple expressions based on defined conditions using operators like Equals to (=), Greater than (>), Less than (<), Not equal to (<>), etc.

 

To know more about comparison operators, check this SQL Comparison Operators with Examples.