Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
niranjankumark
Posting Yak Master
164 Posts |
 Posted - 2008-03-18 : 07:29:00
|
| i am converting DB from sql 2000 to sql 2005.in my DB only one qry has *=(left outer join) syntax. i compiled this SP in sql 2005 , it compiled successfully also executed separately with *= and modified that to left outer join both results same. will it make any harm if it be like sql 2000 syntax (*=). |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-03-18 : 07:49:47
|
| http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=135298&SiteID=1 |
 |
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2008-03-18 : 11:02:33
|
| *= or =* only work in SQL 2005 if your database compatibility level is 8 (SQL 2000) or earlier.You should change your query to use LEFT OUTER JOIN or RIGHT OUTER JOIN.CODO ERGO SUM |
|
|
|
|
|
|
*= ,=*