create table #Birthday ( ID int, [Name] varchar(10), Birthday datetime ) insert into #Birthday select 1,'aa','1999-01-01' union all select 2,'bb','1996-02-29' union all select 3,'cc','1993-03-01' union all select 4,'dd','1966-04-01' union all select 5,'ee','1997-05-01' union all select 6,'ff','1922-11-21' union all select 7,'gg','1989-12-11' --查询2003-12-05到2004-02-28之间的生日 declare @StartTime datetime set @StartTime='2003-12-05' declare @EndTime datetime set @EndTime='2004-02-28' select * from #Birthday where dateadd(year,datediff(year,Birthday,@StartTime),Birthday) between @StartTime and case when datediff(year,@StartTime,@EndTime)=0 then @EndTime else dateadd(year,datediff(year,'19001231',@StartTime),'19001231') end or dateadd(year,datediff(year,Birthday,@EndTime),Birthday) between case when datediff(year,Birthday,@EndTime)=0 then @EndTime else dateadd(year,datediff(year,'1900-01-01',@EndTime),'1900-01-01') end and @EndTime