查询指定时间段过生日的人员

 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 datetimeset @StartTime='2003-12-05'declare @EndTime datetimeset @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 ordateadd(year,datediff(year,Birthday,@EndTime),Birthday) between case when datediff(year,Birthday,@EndTime)=0 then @EndTimeelse dateadd(year,datediff(year,'1900-01-01',@EndTime),'1900-01-01') end and @EndTime