How to add 30 days to a date in SQL Server
I have a Table which shows Course details, in which I have column named "start_date" which tells when the course was started and another column named "course_duration" which shows number of days of this course. So based on the 2 columns, I want to calculate the end_date of the course (i.e. end_date=start_date+30days). How do I achieve that using a select query in SQL Server?