[Solved] What is wrong with this SQL procedure snippet?DECLARE @counter INT = 0;WHILE @counter < 3BEGIN SET @counter = @counter + 1;ENDPRINT @counter; | SQL

SQL - Stored Procedures and Functions

What is wrong with this SQL procedure snippet?

DECLARE @counter INT = 0;
WHILE @counter < 3
BEGIN
 SET @counter = @counter + 1;
END
PRINT @counter;

APRINT statement is outside BEGIN...END block

BNo PRINT statement inside loop to show progress

CNo syntax error; code runs and prints 3

DVariable @counter is not initialized

Step-by-Step Solution

Solution:

Step 1: Analyze loop and variable initialization
@counter starts at 0, increments to 3 correctly.
Step 2: Check PRINT statement placement
PRINT after loop is valid and prints final value 3.
Final Answer:
No syntax error; code runs and prints 3 -> Option C
Quick Check:
Code runs fine and prints final counter [OK]

Quick Trick: PRINT can be outside loop; no error if variable initialized [OK]

Common Mistakes:

Master "Stored Procedures and Functions" in SQL

9 interactive learning modes - each teaches the same concept differently

More SQL Quizzes

What is wrong with this SQL procedure snippet?