SQL Server Operators

Level : Beginner

Mentor: Shailendra Chauhan

Duration : 00:02:00

Arithmetic Operators

Arithmetic operators perform mathematical calculations on numeric values.

SELECT 5 + 3 AS Addition, 10 - 4 AS Subtraction, 6 * 2 AS Multiplication, 16 / 4 AS Division;

Relational operators compare values to determine if they meet specific relationships (e.g., equal, not equal, greater than, less than).

SELECT 5 = 5 AS Equal, 10 <> 5 AS NotEqual, 8 > 3 AS GreaterThan, 3 < 7 AS LessThan;

The assignment operator (=) assigns a value to a variable.

DECLARE @x INT;
SET @x = 10;
SELECT @x AS Result;

SQL Server uses schema and table names separated by a dot (.) to resolve the scope of an object.

SELECT dbo.Employee.Name FROM dbo.Employee;

Bitwise operators perform operations at the bit level for integers.

DECLARE @a INT = 5, @b INT = 3;
SELECT @a & @b AS BitwiseAND, @a | @b AS BitwiseOR, ~@a AS BitwiseNOT;

Set operators combine or compare result sets from multiple queries.

SELECT employee_id FROM Employees
UNION
SELECT employee_id FROM FormerEmployees;

Comparison operators compare values to evaluate conditions in SQL queries.

SELECT product_name FROM Products WHERE price > 50;

The concatenation operator (+) combines strings in SQL Server.

SELECT first_name + ' ' + last_name AS full_name FROM Employees;

Compound operators combine an operation with the assignment (e.g., +=, -=).

DECLARE @total INT = 10;
SET @total += 5;

Unary operators work on a single operand.

SELECT -5 AS Negation, NOT 1 AS LogicalNOT;

Logical operators combine conditions to evaluate logical expressions.

SELECT product_name FROM Products WHERE in_stock = 1 AND price < 50;

Still have some questions? Let's discuss.