Display Years

Question

Hi how can i display current year to next 15 years by using sql.

Sarath Kumar · Answer

actually i have a table year. in that MonthIdMonthnameCreateDate parameters are there. now i want to save values from 2014 to 2030 by using stored procedure. now you can understand

Ankur Jain · Answer

Hi! SorryI didn't get your question properly but here is the query to get next year or how many of year next to current year you want to get you just add number in query then you will get the next year .. select CONVERT(datetime CONVERT(VARCHAR(20) YEAR(GETDATE())+15) + '.01.01')

Sarath Kumar · Answer

Need to dispaly years..... for example i need to display 2014 to 2030

Dipankar Biswas · Answer

SELECT datepart ( yyyy  getdate ())