[Solved] What will be the output of the following SQL procedure snippet?DECLARE @num INT = 2;WHILE @num <= 4BEGIN PRINT @num; SET @num = @num + 1;END | SQL

SQL - Stored Procedures and Functions

What will be the output of the following SQL procedure snippet?

DECLARE @num INT = 2;
WHILE @num <= 4
BEGIN
 PRINT @num;
 SET @num = @num + 1;
END

A1 2 3 4

B2 3 4

C2 3 4 5

DNo output

Step-by-Step Solution

Solution:

Step 1: Initialize variable
@num starts at 2.
Step 2: Loop condition
Loop runs while @num <= 4.
Step 3: Loop iterations
Prints 2, increments to 3; prints 3, increments to 4; prints 4, increments to 5; loop ends.
Final Answer:
2 3 4 -> Option B
Quick Check:
Loop prints values from 2 to 4 inclusive [OK]

Quick Trick: Loop prints from start to end value inclusive [OK]

Common Mistakes:

Master "Stored Procedures and Functions" in SQL

9 interactive learning modes - each teaches the same concept differently

More SQL Quizzes

What will be the output of the following SQL procedure snippet?