sql常用脚本

常用sql脚本汇总

1 SQLserver

1.1 生成日期列

WITH DateSequence AS (
    SELECT convert(char(10),'2024-01-01',120) AS DateValue
    UNION ALL
    SELECT convert(char(10),dateadd(day, 1, DateValue),120)  AS DateValue
    FROM DateSequence
    WHERE DateValue < '2024-08-13'
)
SELECT DateValue FROM DateSequence
OPTION (MAXRECURSION 0);-- 允许无限递归，或设置一个足够大的数字以避免栈溢出