Why Variables and SET statements in SQL? - Purpose & Use Cases

The Big Idea

What if you could let SQL do the math for you, step by step, without losing track?

The Scenario

Imagine you are calculating monthly sales totals by hand using a calculator and paper. Every time you want to add a new sale, you have to remember the previous total and add the new amount manually.

The Problem

This manual method is slow and easy to mess up. You might forget the last total, make addition mistakes, or lose track of intermediate results, causing frustration and errors.

The Solution

Using variables and SET statements in SQL lets you store values temporarily and update them step-by-step inside your queries or scripts. This way, the computer keeps track of your calculations accurately and quickly.

Before vs After

✗ Before

Calculate total = 100 + 200 + 150 manually each time

✓ After

DECLARE @total INT; SET @total = 0; SET @total = @total + 100; SET @total = @total + 200; SET @total = @total + 150;

What It Enables

It enables you to perform stepwise calculations and store temporary results inside your SQL scripts, making complex data processing easier and error-free.

Real Life Example

When generating a report that sums sales per region, you can use variables to keep a running total as you process each row, instead of recalculating everything repeatedly.

Key Takeaways

Variables store temporary values during SQL execution.

SET statements assign or update these variable values.

This approach simplifies calculations and reduces errors.