SELECT TOP 1000 Num=IDENTITY(INT,0,1) INTO Num FROM syscolumns
DECLARE @d1 DATETIME, @d2 DATETIME
SELECT @d1 = '2015-04-01', @d2 = '2016-03-31'
SELECT [day] = CONVERT(VARCHAR, DATEADD(dd, Num, @d1), 23)
FROM Num
WHERE Num <= DATEDIFF(dd, @d1, @d2)
--如不再需要Num表
DROP TABLE Num
向一个表的列循环插入一年的日期
最新推荐文章于 2024-07-19 03:25:55 发布