The SQL server date function provides an easy way to calculate the number of days in a month.
To calculate the total number of days in each month in SQL server, you can use datediff as shown:
Select datediff(dd,'Feb 1, 2000','Mar 1, 2000')
This will give a result of 29 days. This method also works correctly for leap years.