在where子句SQL中引用计算列

除了Aaron的答案，您还可以使用公用表表达式：

;with cte_FreeDaysRemaining as    (        select frdFreedays - DateDiff(dd,conReceiptToStock,GetDate()) As FreeDaysRemaining --, more columns        from yourtable    )    select        FreeDaysRemaining        --, more columns    from cte_FreeDaysRemaining    where FreeDaysRemaining <= @intFreeDays