I have to agree with Tom and Gail about the question.  I got it wrong, so I tested it on SQL 2016 SP1 and the query does return 2 rows.

I find that I don't get a lot of uninterrupted time at work, so I try to carve out some for myself by ignoring my phone and email for a...

The success or failure of a code review process depends on the motivation behind it, much like Tom describes.  If it's used to ensure good, performant, maintainable code gets into...

I think Sue hit the nail on the head.  If you look at https://docs.microsoft.com/en-us/sql/relational-databases/system-stored-procedures/sp-send-dbmail-transact-sql, you'll see that the @recipients parameter is definitely a varchar.  There are other parameters...