Return
-
Title
When optimizing, application gives "this type of sql statement not supported" error. -
Description
I am trying to optimize queries but some of them give me the error "this type of sql statement not supported".
Example:
SELECT TOP (100) PERCENT dbo.T_CONTACT.CONTACT_ID
FROM dbo.T_CONTACT
WHERE dbo.T_CONTACT.FLAG = 1 -
Cause
Older versions of Optimizer do not support Top (n) Percent SQL statements.
-
Resolution
Upgrade Toad for SQL Server and the corresponding Optimizer.
-
Additional Information
Toad for SQL Server 3.2 and SQL Optimizer v 6.5 and newer supports Top (n) Percent syntax.