Sql Server 的内置表 master..spt_values n的利用: 具体表内容可自行查询: select * from master..spt_values 1 运用场景生成连续的日期: 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; 1234567 结果: