SQL - Stored Procedures and Functions
You want to create a procedure that inserts numbers 1 to 5 into a table named Numbers using a WHILE loop. Which snippet correctly performs this?
You want to create a procedure that inserts numbers 1 to 5 into a table named Numbers using a WHILE loop. Which snippet correctly performs this?
hard📝 Application Q8 of 15
Step-by-Step Solution
Solution:
Step 1: Check loop condition and increment
DECLARE @i INT = 1; WHILE @i <= 5 BEGIN INSERT INTO Numbers VALUES (@i); SET @i = @i + 1; END loops from 1 to 5, increments @i correctly.Step 2: Verify insert statement and loop logic
Inserts @i value each iteration; loop ends after 5.Final Answer:
DECLARE @i INT = 1; WHILE @i <= 5 BEGIN INSERT INTO Numbers VALUES (@i); SET @i = @i + 1; END -> Option BQuick Check:
Proper increment and condition ensure correct inserts [OK]
Quick Trick: Increment loop variable and check condition to insert correctly [OK]
Common Mistakes:
- Missing increment causing infinite loop
- Wrong loop condition excluding last number
- Decrementing instead of incrementing
Master "Stored Procedures and Functions" in SQL
Want More Practice?
15+ quiz questions · All difficulty levels · Free
Free Signup - Practice All QuestionsMore SQL Quizzes