Storing just Month and Year in SQL Server 2008?
Sql Server will store the datetime data in its entirety (year-month-day hour:min:sec.milliSec) no matter what.
When you store your dates, you can make the day the 1st of the month. Just format the dates how you want when you do your queries.
http://www.sql-server-helper.com/tips/date-formats.aspx
Without knowing the intended use, it is not possible to advise correctly. However, storing month and year is easily done in at least three ways:
- use a date field, but always store into it the first day of the month at midnight; then always custom format the date field for display
- add integer year and month fields, and populate them by splitting a date
- add an integer field where you encode it as year * 100 + month or some other useful scheme