sql语句查询7天内过生日的会员的姓名

例如表members,生日字段MemberBirthday ,相差时间间隔7天

select MemberName,MemberBirthday from Members where dateadd(year,year(getdate())-year(MemberBirthday),MemberBirthday) between getdate() and dateadd(day,7,getdate())