We might need to start with the definition of output. It seems that you are referring to the output of the stored procedure. But I would consider the output of the SQL Batch from reading the question. And obviously the batch never outputs anything, as the return value is silently swallowed in the EXEC statement. But I agree that your understanding was probably more the intention of the author than mine.