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.