SQL：仅将月份和年份列与日期进行比较

没什么好…

DATEDIFF(    month,    DATEADD(Year, MonthlyShipments.Year-1900,        DATEADD(Month, MonthlyShipments.Month-1, 0)),    GETDATE()    ) BETWEEN 1 AND 3

但是，可以将嵌套的DATEADD用作计算列和索引列

ALTER TABLE MonthlyShipments ADD    ShipDate AS DATEADD(Year, MonthlyShipments.Year-1900, DATEADD(Month, MonthlyShipments.Month-1, 0)    )

这使

WHERe DATEDIFF(month, ShipDate, GETDATE()) BETWEEN 1 AND 3