SQL 实习生日提醒

3天后生日的：

select   *   from   staff   where   datepart(m,staff_time)=datepart(m,getdate())   and   datepart(d,staff_time)=datepart(d,getdate())+3
几天生日的：
select   *   from   staff   where   datepart(m,staff_time)=datepart(m,getdate())   and   datepart(d,staff_time)=datepart(d,getdate())
3天内生日的：

select   *   from   staff   where   datepart(m,staff_time)=datepart(m,getdate())   and   datepart(d,staff_time)> =datepart(d,getdate())   and   datepart(d,staff_time) <=datepart(d,getdate())+3