SQL 问题

Question

     数据表  HYXX    
     字段   CSRQ
     达到的效果:
    
        以系统时间为准 找寻出10以内过生日的信息！
    

Answer 1

select * from HYXX where datediffy(day,csrq,getdate())<=10

Answer 2

select * from HYXX where abs(datediff(day,csrq,getdate()))<=10包括前后

Answer 3

select * from tb 
where CSRQ between getdate() 
and dateadd(day,10,dateadd(year,datediff(year,CSRQ,getdate()),CSRQ)

Answer 4

select * from HYXX where datediffy(mm,csrq,getdate())=0 and  datediffy(day,csrq,getdate())<=10

Answer 5

   数据库是2000   不支持datediffy  谢谢！

Answer 6

select * from HYXX where abs(datediff(dd,dateadd(yy,-datediff(yy,0,csrq),csrq),dateadd(yy,-datediff(yy,0,getdate()),getdate())))<=10

Answer 7

丢了个括号select * from tb 
where CSRQ between getdate() 
and dateadd(day,10,dateadd(year,datediff(year,CSRQ,getdate()),CSRQ))

Answer 8

   谢谢回答！但是你的SQL好像没有达到我要的效果！