Denis Gobo has been posting SQL Server Teasers.  The one on UPDATE is interesting.

Hint: When SQL is being rational, it usually behaves like C.