Tag: sql operator

How to Use SQL SUM Function

10:01 Database development, Statements

SQL is a powerful and widely-used programming language for data storage, retrieval, and...
Read More

SQL UNION Cheat Sheet with 10 Easy and Useful Tips

13:00 Database development, Statements

Having a hard time with SQL UNION? It happens if the results you combined put your SQL Server into a standstill. Or a report that’s been...
Read More

Using Alerts and Operators in SQL Server

02:06 Database administation, Database Optimization & Structure, Security

Introduction With all the advancements in SQL Server and data, it feels great that such native SQL tools as Alerts and Operators are still...
Read More

T-SQL Regular Expression: LIKE Operator and Its Use-Cases

02:45 Languages & Coding, T-SQL • One Comment

A Regular Expression (Regex) is a rule defining how characters can appear in an expression. In...
Read More

T-SQL SET Operators Part 2: INTERSECT and EXCEPT

02:58 Database development, Statements, T-SQL

In my previous article, I explained the basics of set operators, their types, and prerequisites for their use. I also talked about UNION...
Read More

Basic and Complex Uses of Not Equal Comparison Operator in T-SQL

00:15 Languages & Coding, T-SQL

This article is focused on the T-SQL Not Equal comparison operator (<>) and its uses in basic to slightly complicated SQL scripting...
Read More

T-SQL SET Operators Part 1: UNION and UNION ALL

02:18 Languages & Coding, T-SQL • One Comment

In SQL Server, we can combine the same type of data from multiple tables using SET operators. After...
Read More

Advanced SQL: CROSS APPLY and OUTER APPLY

17:23 Database development, Statements

In this article, we’ll look into the “APPLY” operator and its variations – CROSS APPLY and OUTER APPLY along with examples of...
Read More
Close