|
select
dateadd
(dd,
number
,
cast
(
DatePart
(
year
,
getdate
())
as
char
(
4
))
+
'
-01-01
'
)
as
日期
from
master..spt_values
where
type
=
'
p
'
and
number
<=
datediff
(dd,
cast
(
DatePart
(
year
,
getdate
())
as
char
(
4
))
+
'
-01-01
'
,
cast
(
DatePart
(
year
,
getdate
())
as
char
(
4
))
+
'
-12-31
'
) |
|
转播
