Thanks for this interesting QOT which proves me that even having spend more than 40 hours to study the operators , I have always a long way up to understand the operators. It is a question I have neglected up to SQL Server 2012 , as I was interested mainly by SMO and T-SQL.

I have reopened an old book ( Inside Microsoft SQL Server 2005 : T-SQL querying ) to see that it was dealing about this topic. I think I will study it and do the same work for the 2008 R2 and 2012 versions before dealing 2014. A long way but I have time enough now.