• First result depends on what has been run previously in the query window. If nothing has been run, then get a 1, second result is 1.

    If a SET option e.g. SET NOCOUNT ON/OFF has been done first, then the first result is a 0