[Solved] Given this procedure snippet:DECLARE @sum INT = 0;DECLARE @n INT = 1;WHILE @n <= 4BEGIN SET @sum = @sum + @n; SET @n = @n + 1;ENDSELECT @sum;What is the output? | SQL

SQL - Stored Procedures and Functions

Given this procedure snippet:

DECLARE @sum INT = 0;
DECLARE @n INT = 1;
WHILE @n <= 4
BEGIN
 SET @sum = @sum + @n;
 SET @n = @n + 1;
END
SELECT @sum;

What is the output?

A10

B4

C0

DError

Step-by-Step Solution

Solution:

Step 1: Calculate sum inside loop
Sum adds 1+2+3+4 = 10 as @n increments from 1 to 4.
Step 2: Confirm final output
After loop ends, SELECT returns 10.
Final Answer:
10 -> Option A
Quick Check:
Sum of 1 to 4 = 10 [OK]

Quick Trick: Sum increments inside loop; final value is total sum [OK]

Common Mistakes:

Master "Stored Procedures and Functions" in SQL

9 interactive learning modes - each teaches the same concept differently

More SQL Quizzes

Given this procedure snippet: