SQL创建日历 包含年月日/周/星期几
CREATE TABLE date
(
id INT IDENTITY (1,1),
date NVARCHAR(50),
year INT,
month INT,
day INT,
week INT ,
weekday NVARCHAR(10)
)
DECLARE @NowDATE DATETIME=‘2022.01.01 00:00:00’
DECLARE @i INT = 1
WHILE @i<=3650
BEGIN
INSERT INTO dbo.date
(
date,
year,
m
原创
2022-02-18 10:36:49 ·
1167 阅读 ·
0 评论