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
'
)
sql中生成365天语句
最新推荐文章于 2023-05-23 17:59:51 发布