Yes. In Editor, right-click and choose Refactor: convert to/from ANSI join. The query builder also offers this functionality. For example, you can send Editor contents to the query builder to “see” your query. It will convert this automatically for you, then you can always send it back to Editor.
Related Articles
SQL SERVER Management Studio – Exception of type...
I was trying to help my client in generating a report large data set. After spending some time and understanding the schema, I could provide them the query to get the results. Now, he wanted to save t...
Viewing the SQL Alternatives and Execution Run Time Statistics
This tip explains how you can view the SQL alternatives generating in the Batch Optimizer in the Tuning Lab. After a SQL statement has been optimized in the Batch Optimizer in Quest SQL Optimizer for...
SQL Optimizer for SAP ASE Index Usage Analyzer
In this SQL Optimizer for SAP ASE video, we demonstrate how to use the Index Usage Analyzer to determine which indexes are not being used....
