SQL实现生日提醒

40天前提醒

SELECT Birthday
FROM LinkMan_Info_System
WHERE (MONTH(Birthday) <= MONTH(DATEADD(DAY, 40, GETDATE())))
AND (DAY(Birthday) <= DAY(DATEADD(DAY, 40, GETDATE())))
AND (MONTH(Birthday) >= MONTH(GETDATE()))
AND (DAY(Birthday) >= DAY(GETDATE()))