Sql Server 的内置表 master..spt_values n的利用:
具体表内容可自行查询:
select * from master..spt_values
运用场景生成连续的日期:
SELECT
CONVERT (VARCHAR (100),dateadd(d, number, GETDATE() + 1 - 7),23) AS every_time
FROM
master..spt_values n
WHERE
n.type = 'p'
AND n.number <= 7;
结果: