摘要： 背景：要自动生成一个日期表 DECLARE @year INT=year(getdate()); --DECLARE @year INT=year(:endTime); WITH t AS (SELECT CAST( CAST(@year AS VARCHAR(4)) + '-1-1' AS DAT 阅读全文