Quiz: The BREAK Keyword in T-SQL

Quiz: BREAK

On this quiz, when [NULL] is an option, interpret that as nothing is returned
  • BREAK;

    PRINT 2;
  • WHILE 1 = 1
        BREAK;
        PRINT 2
  • WHILE 1 = 1
    IF 1 = 1
        PRINT 2
        BREAK;
  • WHILE 1 = 1
    BEGIN
        BREAK;
        PRINT 2;
    END

Compare how you did with others, and get more details on the answers

Stay tuned: a post will go live on the blog later this week recapping how folks did on each question, and why this works the way it does.

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.