Hi all
Is there any best way to get month name in SQL SERVER 2005.
I know that we can do this using our own function, but just i want to conform that if SQL SERVER provide any function for month name if we have month number i.e. 1,2..12

Thanks