I would certainly agree with Hugo - this just smells like bad practice if it ends up in production code. OK, the question is fine as an academic exercise, but just because you can do something like this doesn't mean you should, IMHO.

btw - I got it wrong - probably because my style of coding doesn't give me enough practice at this kind of dubious T-SQL 😉