Advanced SQL: CROSS APPLY and OUTER APPLY
In this article, we’ll look into the “APPLY” operator and its variations – CROSS APPLY...
Concatenation in Transact-SQL
Introduction Assuming you maintain a table containing customer data, and your boss asks you to send him the current list of customers and...
SQL Server CRUD Operations
In database programming, there are four fundamental operations: create, read, update, and delete – CRUD operations. They are the first...
Using DATEADD, DATEDIFF and DATEPART T-SQL Functions in Simple Terms
This article focuses on developing a basic understanding of how to use one of the most common...
MERGE: Updating Source and Target Tables Located on Separate Servers
What is the MERGE statement? Using the MERGE statement, we can change data in a target table based on data in a source table. Using it, we...
Similarities and Differences among RANK, DENSE_RANK and ROW_NUMBER Functions
The RANK, DENSE_RANK and ROW_NUMBER functions are used to retrieve an increasing integer value. They start with a value based on the...
Understanding Difference between EXCEPT and NOT IN Operators
Both EXCEPT and NOT IN operators are used to filter records from a table based on a specific...
Understanding GROUPING and GROUPING_ID Functions in SQL Server
The ROLLUP and CUBE operators are used to return results aggregated by the columns in the GROUP BY clause. The GROUPING and GROUPING_ID...
Exploring SQL Server 2016 Query Store GUI
Introduction Query store is a new feature, introduced in SQL Server 2016, that allows database administrators to historically review...
Unleash the Power of SQL Pivot and Unpivot: A Complete Guide to Data Transposing Techniques
Data manipulation is an essential skill for anyone working with SQL databases. It allows you to...
