X++ SQL 代码转换为 SQL Server 代码
以下是转换后的 SQL Server 代码：
SELECT * FROM IdcfPurchApprovalInfo INNER JOIN IdcfCodeLine AS IdcfCodeLine_1 ON IdcfPurchApprovalInfo.IdcfDrafterDept LIKE IdcfCodeLine_1.IdcfCodeFreeStrSpace2 + '%' LEFT JOIN IdcfCodeLine AS IdcfCodeLine_1_1 ON IdcfCodeLine_1.IdcfCodeFreeStrSpace = IdcfCodeLine_1_1.IdcfCodeFreeStrSpace WHERE IdcfPurchApprovalInfo.IdcfPurchOrderId IS NOT NULL AND (IdcfPurchApprovalInfo.IdcfDrafterDept != '' AND (IdcfCodeLine_1_1.IdcfCodeFreeStrSpace2 = '20' OR IdcfCodeLine_1_1.IdcfCodeFreeStrSpace2 = '20*' OR IdcfCodeLine_1_1.IdcfCodeFreeStrSpace2 = '') AND (IdcfPurchApprovalInfo.IdcfDrafterId = 'hongmin.liang' OR IdcfPurchApprovalInfo.IdcfApplicantId = 'hongmin.liang')) AND IdcfPurchApprovalInfo.IdcfDrafterDept IS NOT NULL AND IdcfCodeLine_1_1.IdcfCodeFreeStrSpace2 IS NOT NULL AND IdcfCodeLine_1.IdcfTypeCd = N'355' AND IdcfCodeLine_1_1.IdcfTypeCd = N'355'
原文地址: https://www.cveoy.top/t/topic/jLoE 著作权归作者所有。请勿转载和采集!