将 X++ SQL 代码转换为 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 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)