Showing posts with label appreciatesome. Show all posts
Showing posts with label appreciatesome. Show all posts

Sunday, February 12, 2012

Compatibility between SQL Server 2000 and 2005

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?