I was writing a query and managed to mistype INTERSECT, I typed INTERCEPT and to my surprise the query ran, it returned 2 result set just as if INTERCEPT wasn't there at all Try it yourself CREATE TABLE testnulls (ID INT) INSERT INTO testnulls VALUES (1) INSERT INTO testnulls VALUES (2) INSERT INTO testnulls VALUES (null) CREATE TABLE testjoin ...

In the last months, I got the infamous ''it's by design'' answer for many bugs/issues/irrational behaviors I posted to Microsoft. For most of them I used the Connect web site, in a couple of cases I opened a formal incident to Microsoft support. There are a lot of story (in and outside Microsoft) about the ''it's by design'' excuse and most of ...