查询3天内过生日的SQL语句

select * from T_Employee
where DATEDIFF(day,GetDate(),Convert(varchar(5),DatePart(yyyy,GetDate()))+
        '-'+Convert(varchar(5),DATEPART(mm,BirthDay))
        +'-'+Convert(varchar(5),DATEPART(dd,BirthDay))) between 0 and 3

 PS：表名-T_Employee；生日字段名-DateOfBirth。