Outer join in SQL Statement

• Johann

  Grasshopper

  Points: 12

  More actions

  February 13, 2006 at 6:44 am

  #166852

  Hello All!

  I am a developer and write SQL and SPs every day; some days all it is is SPs. Anyway, I had heard a rumor that the outer join "function" using '*=' in the WHERE clause, is going to be deprecated in SQL 2005 (we use SQL 2000). Does anyone know if this is true? I thought that the '*=' syntax was ANSI standard. I could be wrong though. I want to make sure my code is going to work with the new version of SQL Server.

  Thanks!

• Joseph Mulhall

  SSCarpal Tunnel

  Points: 4672

  More actions

  February 13, 2006 at 7:07 am

  #620404

  *= was a Transact-SQL shorthand, not an ANSI standard.