CREATE TABLE Employee.Person ( PersonId INT PRIMARY KEY, Name VARCHAR(50), DateBirth DATETIME, )
SELECT * FROM Employee.Person WHERE DateBirth BETWEEN @PeriodBegin AND @PeriodEnd