servlet如何获取select 选中的option的值_sql server 2012应用之，如何计算本年度的每个月有多少天？...

/*
功能：如何计算本年度的每个月有多少天？
作者：felix
日期：20200521
*/

DECLARE @dbegin DATE = DATEADD(YEAR, DATEDIFF(YEAR, 0, GETDATE()), 0); --获取本年第一天
DECLARE @dend DATE = DATEADD(DAY, -1, DATEADD(YEAR, DATEDIFF(YEAR, 0, GETDATE()) + 1, 0)); --本年最后一天
WITH ctea (ddate) --生成日期序列
AS (SELECT @dbegin AS ddate
    UNION ALL
    SELECT DATEADD(DAY, 1, ddate)
    FROM ctea
    WHERE ddate < @dend)
SELECT MONTH(ddate) AS imonth,
       --按月份分组统计天数
       COUNT(*) AS idays
FROM ctea
GROUP BY MONTH(ddate)
OPTION (MAXRECURSION 0);