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

• What message types exist in SQL Server 2005 Service Broker?
• When discussing image support in Report Builder, which of the following is the most accurate statement?
• What would happen when you execute the code below in Query Analyzer (SQL Server 2000) Submitted by Jacek Osuchowski...
• You cannot execute procedures on the 2005 server. Why not?
• What does the CEILING() function do?
• In configuring the thesaurus configuration file for SQL Server 2005 Full-Text Search, you set the diacritics_sensitive value to 1. What does this mean?
• When creating a full-text index on a BLOB column ...
• What is the default type of XML data if you do not specify an arguement?
• You have a SQL Server 2005 cluster and need to add anti-virus software as per your corporate standards. What should you exclude from scans?
• What does CONTINUE do in T-SQL?
• More...