How about temptables, session context, CLR functions, etc.?

If they were supported, it would be so cool. But the cons currently outweigh the pros.

The optimizer doesn't consider Rules, as it does with the Constraints. Changing the data type...

It takes one to know one.

I disagree with the answers. The first one is correct- after the second insert it's transfered into the catch statement and the XACT_STATE = -1

Also if you have case sensitive collation, you spell ages with both uppercase letter and lowercase letter. That would also return 0 rows.