SQL写一段语句提醒每年员工生日日期

Question

SQL如何写一段语句提醒每年员工生日日期，到期前10天提醒，谢谢各位!

Answer 1

参考一下这个 sqlserver
员工出生日期格式是：1990-6-26
有若干个员工
写出SQL(Sql Server 2008)根据不同查询时间（getdate（））
查询出所有满足未来45天内生日的员工信息
还是自己贴答案大家分享下吧
SELECT E.Code,E.Name,E.BornDate,D.NAme AS sDept,ZW.Name AS SZhiWu ,E.PyDate ,datediff(DAY,DATEADD(Year,DATEDIFF(Year,BornDate ,getdate()),BornDate),getdate()) as cyts
FROM ZlEmployee E
LEFT JOIN ZlDept D ON E.Dept=D.Code
LEFT JOIN E_ZhiWu ZW ON E.ZhiWu=ZW.Code
where datediff(DAY,DATEADD(Year,DATEDIFF(Year,BornDate ,getdate()),BornDate),getdate())between 0 and 45
and E.state not in ('09')
order by datepart(day,E.Borndate),E.code