Statements

Concatenation in Transact-SQL

Languages & Coding, Statements, T-SQL

Introduction Assuming you maintain a table containing customer data, and your boss asks you to send...
Read More

SQL Server CRUD Operations

Statements

In database programming, there are four fundamental operations: create, read, update, and delete – CRUD operations. They are the first...
Read More

Using DATEADD, DATEDIFF and DATEPART T-SQL Functions in Simple Terms

Database development, Statements • 11 Comments

This article focuses on developing a basic understanding of how to use one of the most common Transact-SQL date functions: DATEADD,...
Read More

MERGE: Updating Source and Target Tables Located on Separate Servers

Database development, Statements, Tables

What is the MERGE statement? Using the MERGE statement, we can change data in a target table based...
Read More

Similarities and Differences among RANK, DENSE_RANK and ROW_NUMBER Functions

Database development, Statements • One Comment

The RANK, DENSE_RANK and ROW_NUMBER functions are used to retrieve an increasing integer value. They start with a value based on the...
Read More

Understanding Difference between EXCEPT and NOT IN Operators

Database development, Statements

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...
Read More

Understanding GROUPING and GROUPING_ID Functions in SQL Server

Database development, Statements

The ROLLUP and CUBE operators are used to return results aggregated by the columns in the GROUP BY...
Read More

Exploring SQL Server 2016 Query Store GUI

Database development, Statements

Introduction Query store is a new feature, introduced in SQL Server 2016, that allows database administrators to historically review...
Read More

Unleash the Power of SQL Pivot and Unpivot: A Complete Guide to Data Transposing Techniques

Database development, Statements

Data manipulation is an essential skill for anyone working with SQL databases. It allows you to transform and analyze data, making it more...
Read More

Calculating Running Total with OVER Clause and PARTITION BY Clause in SQL Server

Database development, Statements • One Comment

You often come across scenarios where you have to calculate a running total of a quantity. A...
Read More
Close