Changing values with another value

Question

Hi,
I have a simple query that getting some datas like below;

ID , Month 
1       5
2       12
3        3


For example I want to change "Month" column's value. For example if there is 1, and I'll show with January. And if there is 12, I'll show December.

How can I do that with MSSQL?

Regards.

Answer 1

I really doubt that we can read credentials :(