请问如何输出今年所有天数?

Question

请问如何输出今年所有天数?表格的结果如下：
2010-01-01
2010-01-02
2010-01-03
...
2010-12-31

Answer 1

select dateadd(dd,rn,ltrim(year(getdate()))+'0101')
from
(select top 1000 rn=row_number() over(order by getdate())-1 from sys.objects,sys.columns) t
where
dateadd(dd,rn,ltrim(year(getdate()))+'-01-01')<=ltrim(year(getdate()))+'-12-31'

Answer 2

select
date = dateadd(day,number,ltrim(year(getdate())))
from
master..spt_values
where
type = 'P' and dateadd(day,number,ltrim(year(getdate()))) < ltrim(year(getdate())+1)/*
date
-----------------------
2010-01-01 00:00:00.000
...
2010-12-31 00:00:00.000(365 行受影响)
*/

Answer 3

http://blog.csdn.net/xys_777/archive/2010/06/20/5681208.aspx