I got the correct answer:
SELECT * From TABLE
WHERE Datepart(day,DATEFIELD) between datepart(day, @from_date)
and Datepart(day,@to_date)
and
Datepart(month,DATEFIELD) between datepart(month, @from_date)
and Datepart(month,@to_date)
Here, this Query will fetch Birthdays between date provided. Thanks to Everyone for their precious Knowledge and Information. :)