34,588
社区成员
发帖
与我相关
我的任务
分享
;with cte as
(
select cast('2012-01-01' as datetime) date
union all
select dateadd(day,1,cte.date) from cte where year(dateadd(day,1,cte.date))=2012
)
select * from cte
left join ......
option (maxrecursion 1000)