Upgrading non-ansi outer joins (*= and =*) with Toad for SQL Server (4242700)

Chat now with support

Return

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title

Upgrading non-ansi outer joins (*= and =*) with Toad for SQL Server
Description

Is it possible to upgrade the old-style outer joins *= and =* with 'LEFT OUTER JOIN' or 'RIGHT OUTER JOIN' in Toad for SQL Server?

For example, the SQL script contains the non-ansi outers i.e. *= (LEFT OUTER JOIN) and =* (RIGHT OUTER JOIN) but these are no longer supported in SQL Server 2005 and SQL Server 2008.
Resolution

This is not currently possible.

WORKAROUND:
None.

STATUS:
Enhancement request CR 59,956 has been submitted to Development for consideration in a future release of Toad for SQL Server.
Defect ID

CR 59,956

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Upgrading non-ansi outer joins (= and =) with Toad for SQL Server (4242700)