title: Update Month value on datefield in MS sql 2005
body: <p>I need a way to update the month value on a dateTime field in my db. I'm being past an int value for the month and need to use that for the update. 
  Is it possible to do this in the sql statement or would I be best doing it in c# in the webservice?</p>