Concatenation in Transact-SQL
Introduction Assuming you maintain a table containing customer data, and your boss asks you to send...
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 Transact-SQL date functions: DATEADD,...
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...
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 criterion. In this article, we will look at...
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...
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 transform and analyze data, making it more...
Calculating Running Total with OVER Clause and PARTITION BY Clause in SQL Server
You often come across scenarios where you have to calculate a running total of a quantity. A...
