Skip to Content
0
Former Member
Apr 27, 2009 at 02:10 PM

Migrating from Oracle to SQL Server - SQL HINTS

35 Views

We are migrating an SAP landscape from HP-UX / Oracle to Windows / SQL Server. We have numerous custom programs with OPEN SQL Hint statements of the form:

select aqmnum akunum aobjnr azztaxtype a~zzservcenter

azzassmpriok azzaudittype a~zzdr840dt

into corresponding fields of table lt_qmel

from qmel as a

inner join ihpa as b

on aobjnr = bobjnr

where a~qmart IN ('Z7','Z8','Z9','ZU','ZD')

and b~parnr = sy-uname

*%_hints oracle*

*'INDEX("&TABLE&" "IHPAP" "IHPAP")'.*

Question: What is the best way to make these SQL statements compatible with SQL Server?

Thanks