One approach would be to store the actual date in your database and then use the
DATEPART[
^] function to filter your records by month and year.
For example if you want to retrieve all records which have year 2012 and month 11 your where clause would look like this
WHERE DATEPART(YEAR,[YourDateColumn]) = 2012 AND DATEPART(MONTH,[YourDateColumn]) = 11