*= and =* operators can not run on sql 2012

Aug 27, 2014 at 2:01 AM

I not sure mean of above 2 operators, and it can not run on sql server 2012.

Please let me know about them if somebody know them!

Aug 27, 2014 at 2:41 PM

In earlier versions of Microsoft® SQL Server™, left and right outer join conditions were specified in the WHERE clause using the *= and =* operators. In some cases, this syntax results in an ambiguous query that can be interpreted in more than one way. Because of this (and maybe other reasons that I don't know), Microsoft deprecated the old TSQL style joins. Check out this link. Here are a couple sites that might help explain Using Outer Joins and Writing Outer Joins in T-SQL. This article A Visual Explanation of SQL Joins might help as well.

Aug 28, 2014 at 2:22 AM
Thanks ghuey!