Upgrading to compatibility 90 in sql server 2005

  • Hi,

    We are upgrading to sql server compatibilty level to 90 from 80. We need to make some chaged in our codes, whereever it is effected. One of them is , we have *= and =* operators are used, BOL says to replace this with OUTER JOIN. My question is operator *= is equivalent to Left outer join ? and =* is right outer join ? I can't seem to find any source on this.

    Thank you,

    VG

  • It depends on the order of the tables. I prefer to think of the * being on the side where all the rows are returned.

    --eg

    SELECT *

    FROM TableA A

    &nbsp&nbsp&nbsp&nbspLEFT JOIN TableB B

    &nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbspON A.AID = B.AID

    -- is either

    SELECT *

    FROM TableA A, TableB B

    WHERE A.AID *= B.AID

    -- or

    SELECT *

    FROM TableA A, TableB B

    WHERE B.AID =* A.AID

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply