循环法(无限制):
DECLARE @BDate varchar(10); --起始日期,格式:'YYYY-MM-DD'
DECLARE @EDate varchar(10); --结束日期,格式:'YYYY-MM-DD'
SET @BDate='2014-01-01';
SET @EDate='2014-06-25';
--生成日期列表
CREATE TABLE #TEMP1(FDAY VARCHAR(10));
DECLARE @dtDay DATETIME;
DECLARE @smDay VARCHAR(10);
SET @smDay=@BDate;
WHILE (@smDay<=@EDate)
BEGIN
INSERT INTO #TEMP1(FDAY) VALUES (@smDay);
SET @dtDay = CAST(@smDay AS DATETIME);
SET @smDay= CONVERT(VARCHAR(10),@dtDay+1 ,120);
END;
SELECT * FROM #TEMP1;
DROP TABLE #TEMP1;