1 2 3 4 5 6 7 8 9 10 11 12
| CREATE TABLE TbDates
(
date DATETIME NOT NULL CONSTRAINT PK_TbDates_date PRIMARY KEY,
annee AS (YEAR(date)) PERSISTED NOT NULL,
mois AS(MONTH(date)) PERSISTED NOT NULL,
semaineDansAnnee AS(DATEPART(week, date)) PERSISTED NOT NULL,
semaineDansLeMois AS(DATEPART(week, date) - DATEPART(week, DATEADD(day, -DATEPART(day, date) + 1, date)) + 1) PERSISTED NOT NULL,
jourDansAnnee AS (DATEPART(dayofyear, date)) PERSISTED NOT NULL,
jourDansMois AS(DAY(date)) PERSISTED NOT NULL,
jourDansSemaine TINYINT NOT NULL CONSTRAINT CHK_TbDates_jourDansSemaine CHECK(jourDansSemaine BETWEEN 0 AND 7),
)
GO |
Partager