SQLServer 返回一个月的所有天数

select convert(varchar(10),dateadd(DAY,t2.number,t1.day),120) day from
(select '2016-06'+'-01' day) t1,
(select number from MASTER..spt_values WHERE TYPE='P' AND number>=0 and number<=31) t2
where convert(varchar(10),dateadd(DAY,t2.number,t1.day),120) like '2016-06%'select convert(varchar(10),dateadd(DAY,t2.numbe