SQL Server Performance

Need equivilent chart

Discussion in 'General DBA Questions' started by RickO, Jun 2, 2010.

  1. RickO New Member

    Hi all,
    I need to update a number of procs and want to sanity check some of the code I am seeing. What I need is a basic chart to define or show the equivilent of the following:
    A *= B (used in where statement)
    B =* C (used in where statement)
    !=
    These are the ones I found so far.
    Thanks!!
  2. Adriaan New Member

    You're looking at old SQL syntax. The *= and =* operators have been replaced by outer joins. The old syntax was supported until fairly recently, not sure in which version it was actually dropped ...
    Not entirely sure about the != operator, but IIRC it's equivalent to <> (or "not equivalent to", LOL). Not sure if this was part of the old non-join syntax?

Share This Page