Operators in SQL Server with Examples

  Total Views : 514
  Comments : 1
 
  Keywords : SQL server operators, Types of operators in sql server, Different Type sql operators with examples, Arithmetic operators in sql, Logical operators in sql, Assignment operators in sql

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

 

In SQL we have different type of operators those are 

 

     - SQL Arithmetic Operators

 

    - SQL Logical Operators

 

    - SQL Assignment Operators

 

    - SQL Comparison Operators

SQL Arithmetic Operators

By using these operators we can perform multiple operations like addition ( ), subtraction (-), division (/), multiply (*), modulo (%) on SQL statements.

SQL Logical Operators

By using logical operators we can do multiple operations like checking SQL statements based on some conditions like AND, OR, EXISTS, BETWEEN, etc… and comparison of multiple values in SQL statements.

SQL Assignment Operators

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

SQL Comparison Operators

Generally these operators is used to compare multiple expressions based on conditions using operators like Equals to (=), Greater than (>), Less than (<), Not equal to (<>), etc….

 Comments (1)

  • supriya tutlane registered profile image
     
    supriya   Reply

    your previous and next arrow is not working

     Sep 08, 2016

Leave a comment

  • Default Tutlane User