X++ SQL 代码转换到 SQL Server 代码 - 实用指南

以下是将 X++ 代码转换成 SQL Server 代码的结果：

SELECT TOP (100) PERCENT * FROM IdcfPurchLineBackOrderWorkspace WITH (UPDLOCK) ORDER BY IdcfPurchLineBackOrderWorkspace.ExpectedDate ASC, IdcfPurchLineBackOrderWorkspace.ConfirmedDlv ASC WHERE (PurchStatus = 1) AND (NOT (PurchReceivedNow = 0)) JOIN InventDim WITH (UPDLOCK) ON IdcfPurchLineBackOrderWorkspace.InventDimId = InventDim.inventDimId LEFT OUTER JOIN EcoResCategory WITH (UPDLOCK) ON IdcfPurchLineBackOrderWorkspace.ProcurementCategory = EcoResCategory.RecId JOIN PurchTable WITH (UPDLOCK) ON IdcfPurchLineBackOrderWorkspace.PurchId = PurchTable.PurchId AND (IdcfProductReceiptId = 'hongmin.liang') AND (DocumentState = 30 OR DocumentState = 40)