What does CONTINUE do in T-SQL?

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

(Continued from previous question...)

What does CONTINUE do in T-SQL?

Answer: This command restarts a WHILE loop.

Explanation: This statement restarts a WHILE loop, ignoring any other statements after it that might be within the loop.

(Continued on next question...)

Other Job Interview Questions

• What the heck does ATN2 do?
• You want to disable the trigger dEmployee on the HumanResources...
• When a user on a remote SQL Server wants to execute a stored procedure through a linked server on your local server, what security context is used?
• Which of the following is not true about the Raw File Destintion connection in SQL Server 2005 Integration Services?
• What format are images rendered in if they were stored originally in another format?
• You are troubleshooting a Service Broker application ...
• You need to remove a large table from your database ...
• What is a performance consideration of having too many indexes on a production online transaction processing (OLTP) table?
• Which database holds the tables that Database Mail uses to store mail messages and other data in SQL Server 2005?
• Which database holds the tables that Database Mail uses to store mail messages and other data in SQL Server 2005?
• More...