Which of the following two Transact-SQL statements are commonly used with WHILE ?
A. BREAK and CONTINUE
B. BREAK and IF
C. IF and ELSE
D. All of the mentioned
Answer:A
Which of the following two Transact-SQL statements are commonly used with WHILE ?
A. BREAK and CONTINUE B. BREAK and IF C. IF and ELSE D. All of the mentioned
Explanation:The BREAK statement exits the innermost WHILE loop and the CONTINUE statement restarts a WHILE loop.