Is there any Tool to convert SQL Queries into ANSI Format?
-
I don't know, but I can tell you this is not a one to one operation.
You'll need to think about your join predicates to determine which part(s) to use in your join syntax !
So you'll have to examine which parts are join-predicates and which parts are filter (where) predicates !
Johan
Learn to play, play to learn !Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:- How to post Performance Problems
- How to post data/code to get the best help[/url]- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
-
Microsoft SQL 2000 Enterprise Manager will convert this syntax into join syntax
"contains join operators *= or =* "
it will also convert all possible where clauses with Table1.columnX = table2.columnY into joins as well.
(not always desired. a few complex queries will run correctly in Query analyzer and not in EM)
just paste the old code in EM and push the SQL Check button.
cheers,
John R. Hanson
-
Just wanted to chime in with John and say that going to the Views folder in EM and building your query there is the best way to get most/all of your t-sql done for you!
**ASCII stupid question, get a stupid ANSI !!!**
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply