Click here to Skip to main content
15,894,646 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
i have project used sql2005

and when i need to join
write

select *

from A ,B

where
A.ID *= B.ID

'( *= )' is no problem in sql2005
but in sql2012 is not accept that


what i can Do to solve it problem???
Posted
Comments
Maciej Los 27-May-13 13:19pm    
What are you trying to achieve?

1 solution

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.
SQL
SELECT *

FROM 
A
LEFT OUTER JOIN
B

WHERE
A.ID = B.ID

Refer - The query uses non-ANSI outer join operators ("*=" or "=*").[^] for examples.
 
Share this answer
 
Comments
[no name] 27-May-13 15:14pm    
I second
I could not get you.
S.Dwaik 28-May-13 5:27am    
the SQL Server 2012 is not support (*= or =*)

Discontinued Database Engine Functionality in SQL Server 2012
this link see list of different between SQL Server 2012 different and SQL Server 2005 or SQL Server 2008

http://technet.microsoft.com/en-us/library/ms144262(SQL.110).aspx

thnx all
Yes. Thanks... So, use ANSI type.

Thanks for accepting the answer... :)

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900