DBA > Job Interview Questions > Microsoft SQL Server FAQs

In SQL Server 2005 T-SQL, what does the CONTINUE

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

In SQL Server 2005 T-SQL, what does the CONTINUE statement do?

Answer: Restarts a WHILE loop.

Explanation: This statement restarts a WHILE loop. Any statements inside the loop after the CONTINUE command are ignored and the test condition for the WHILE loop is reexecuted.

(Continued on next question...)

Other Job Interview Questions