This operator is discontinued after version 2005.
You can still use it by setting the
COMPATIBILITY_LEVEL
to 80 in
SQL Server 2008 R2
.
But you can't do it in 2012. There is no way to do this in 2012.
Refer -
Outer Join Operator (+) - Oracle to SQL Server Migration[
^].
Solution
Instead of this try the
ANSI
Standard (
LEFT OUTER JOIN
) like below.
Please use this standard as the non-ANSI standards are discontinued after 2005 and in future versions also.
SELECT *
FROM
A
LEFT OUTER JOIN
B
WHERE
A.ID = B.ID
Refer -
The query uses non-ANSI outer join operators ("*=" or "=*").[
^] for examples.