Why Parameters (IN, OUT, INOUT) in SQL? - Purpose & Use Cases

The Big Idea

What if you could send and receive data in one simple step without rewriting everything?

The Scenario

Imagine you have a recipe book where you write down every step of cooking a dish. Now, if you want to change an ingredient or get the cooking time, you have to rewrite the entire recipe each time or guess the details yourself.

The Problem

Manually changing or sharing information like ingredients or cooking time is slow and confusing. You might forget to update some parts or mix up details, causing mistakes and wasted effort.

The Solution

Using parameters like IN, OUT, and INOUT in SQL is like having a smart recipe card where you can input ingredients, get cooking times, and even adjust quantities without rewriting the whole recipe. It makes sharing and updating information clear and easy.

Before vs After

✗ Before

CALL CalculatePrice(100, NULL, NULL); -- manually guessing output

✓ After

CALL CalculatePrice(100, @totalPrice, @discountRate);

What It Enables

It allows you to pass information in, get results back, and even update values dynamically within one simple call.

Real Life Example

Think of an online store where you input how many items you want (IN), get the total price back (OUT), and maybe adjust a discount rate as you go (INOUT) without extra steps.

Key Takeaways

Parameters let you send data into and get data out of database procedures.

IN passes information in, OUT returns results, and INOUT does both.

This makes database tasks faster, clearer, and less error-prone.