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