spt
  • 2024-11-07master..spt_values
    master..spt_values是要导出数据的表,spt_values是在master数据库下,所以是master..spt_values。用法举例获取时间段内的每一天WITHDateSequenceAS(SELECTCAST('2024-11-01'ASDATE)ASDateValueUNIONALLSELECTDATEADD(DAY,1,DateValue)FROMDateSequenceWHERE