X++ SQL 代码转换为 SQL Server 代码示例

SELECT TOP * FROM PurchTable WITH (INDEX = PurchIdx) WHERE (((((((IdcfCodeLine_1_1.IdcfCodeFreeStrSpace2 LIKE '31%') OR (PurchTable.IdcfApplicantDept LIKE '31%')) AND (PurchTable.IdcfApplicantDept LIKE IdcfCodeLine_1_1.IdcfCodeFreeStrSpace2 + '%')) OR (PurchTable.IdcfDrafterId = 'hongmin.liang')) OR (PurchTable.IdcfApplicantId = 'hongmin.liang')) AND (PurchTable.IdcfPurchCategory_1 != '43支払依頼:秘匿'))) LEFT OUTER JOIN IdcfCodeLine AS IdcfCodeLine_1 ON (IdcfTypeCd = N'355') LEFT OUTER JOIN IdcfCodeLine AS IdcfCodeLine_1_1 ON IdcfCodeLine.IdcfCodeFreeStrSpace = IdcfCodeLine.IdcfCodeFreeStrSpace AND (IdcfTypeCd = N'355')