SQL：如何生成给定月份和日期的下一个日期

In my table I have a Month(tinyint) and a Day(tinyint) field. I would like to have a function that takes this month and day and produces a datetime for the next date(including year) given this month and day.In my table I have a Month(tinyint) and a Day(t