it also makes no attempt to validate the string you pass in, so
SELECT PARSENAME('x.y.z', 3)
will always return 'x'
ie it's a simple string-parsing method.

Surely...

also not so easy for anyone who answers based on the actual question 😉

Personally I would cast everything in sight to a decimal - implicit conversions are a complete pain, explicit casting will guarantee the correct result.

I don't think that's the right answer. It always returns nvarchar - but if the input is invalid then the nvarchar value is NULL
If you run 
select...

Got this right as I was hit by it a while back. Still feels like a bug to me, but Microsoft say not so it can't be 😉
 You have...

Never mind the duplicate answers. Under what circumstances would it be a good idea to have ANSI_NULLS set to OFF?

Not that amazing when you consider that the...

Never used the function, but didn't need to know anything about it - there's no where clause, no distinct, so must return 5 rows or give an error, and given...

If that one is correct, then the first option is also correct 😉

The short lesson for all of these context_info questions is surely not to rely on any...

Yup, should definitely be Binary Data, the fact that some other data types get implicitly converted is irrelevant.

Bit of a strange question, teaching me about something I wasn't aware of but which I won't ever use as it's been deprecated!