How to get Month Name in T-SQL

n this example, you will see how to get month name from input data. I have used build in function named DATETIME.