where (dateadd(year,datediff(year,main.birthday,getdate()),main.birthday)) BETWEEN getdate() AND getdate()+@DayNum
SQLserver 统计近N天生日语句
最新推荐文章于 2024-07-13 19:46:47 发布
where (dateadd(year,datediff(year,main.birthday,getdate()),main.birthday)) BETWEEN getdate() AND getdate()+@DayNum