The syntaxes in ASE and MS SQL Server slightly differ. Also, ASE has table hints for prefetch I.O size, buffer replacement strategy and parallelism. In MS SQL Server, those hint options are not present because the server is self-tuning.

• ASE syntax:

… from table_name [(index index_name)] [lock_options]

• MS SQL Server syntax:

… from table_name [with (index (index_name) [, lock_options]]

Example

• ASE:

select * from Test (index Test_i) holdlock where j > 10

• MS SQL:

select * from Test with (index (Test_i), holdlock) where j > 10