• This is a great question, but the answer would be no rows returned because they would still be all NULL since you did not insert or update any rows before the select.

    The answer that is supplied as the correct answer would only be correct if you added a step like this:

    USE AdventureWorks

    UPDATE HumanResources.Employee

    SET SalariedFlag = 'true'

    I want my point for the correct answer:

    A result set with no value (a blank result) will be returned.