Hello there, i really don't know if this is the right forum and i appreciate
some guidance.
I have a problem with the LEFT/RIGHT OUTER JOIN, in 2000 you can made them
in the WHERE clause usring *=/=* and in the last build Microsoft says they'r
e
no longer supporting this sintax, so i have more than 2.5k files (store
procedures, triggers, etc.) to modify.
So I'm looking for a translator that can change the *= syntax for the
SQL-92. I was thinking in a parser because it will not work with a simple
Replace.
Can someone help me?> So I'm looking for a translator that can change the *= syntax for the
> SQL-92.
I don't think this is possible. Because of the structure of the old syntax,
it would be *very* difficult for any software to magically decide which
criteria belong to the join and which are actual filters, and how much would
you trust something that claimed to do so?
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment