SQL - Stored Procedures and Functions
How can you modify a WHILE loop to skip inserting the number 3 into a table but insert all others from 1 to 5?
How can you modify a WHILE loop to skip inserting the number 3 into a table but insert all others from 1 to 5?
hard📝 Application Q9 of 15
Step-by-Step Solution
Solution:
Step 1: Understand skipping logic
To skip 3, check inside loop and only insert if @i is not 3.Step 2: Evaluate options
Use IF inside loop: IF @i != 3 INSERT ... uses IF condition to skip 3; others stop loop or skip increments incorrectly.Final Answer:
Use IF inside loop: IF @i != 3 INSERT ... -> Option AQuick Check:
Conditional insert skips specific value [OK]
Quick Trick: Use IF condition inside WHILE to skip specific values [OK]
Common Mistakes:
- Changing loop condition excludes more than one value
- Using BREAK stops entire loop
- Removing increment causes infinite loop
Master "Stored Procedures and Functions" in SQL
Want More Practice?
15+ quiz questions · All difficulty levels · Free
Free Signup - Practice All QuestionsMore SQL Quizzes