USE MySchool2
GO
DECLARE @StuNo int
select @StuNo='20011'
--select * from Student where StudentNo=@StuNo
DECLARE @NUM int
select @NUM=DATEPART(YEAR,BornDate)
from Student where StudentNo=@StuNo
select * from Student where (DATEPART(YEAR,BornDate)=@NUM+1) OR (DATEPART(YEAR,BornDate)=@NUM-1)
GO
DECLARE @StuNo int
select @StuNo='20011'
--select * from Student where StudentNo=@StuNo
DECLARE @NUM int
select @NUM=DATEPART(YEAR,BornDate)
from Student where StudentNo=@StuNo
select * from Student where (DATEPART(YEAR,BornDate)=@NUM+1) OR (DATEPART(YEAR,BornDate)=@NUM-1)