SQL SERVER
-
编辑 删除
Sqlserver2008下利用递归CTE生成连续日期
with temp as (select convert(datetime,'20120101') days),n as(select days from tempunion allselect n.days+1 from n where n.days<convert(datetime,'20150101'))select * from n option(maxrecursion 32767)...
