报表（补全不存在记录的日期）

最新推荐文章于 2024-08-18 03:25:12 发布

weixin_30729609

最新推荐文章于 2024-08-18 03:25:12 发布

阅读量562

点赞数

文章标签： php 数据库开发工具

原文链接：http://www.cnblogs.com/tianjinquan/p/4181709.html

版权

DECLARE @daysNum INT
DECLARE @currentDay DATETIME
DECLARE @index INT;
DECLARE @NewTable TABLE (
currentDate DATETIME,
realDate DATETIME
)

SET @daysNum = 30
SET @index = 1;
WHILE @index < @daysNum
BEGIN
    SET @currentDay = ( SELECT DATEADD(DAY, @index, GETDATE()) )
    SET @index = @index + 1
    INSERT @NewTable ( currentDate, realDate ) VALUES (CONVERT(VARCHAR(10), @currentDay,112), @currentDay )
END

SELECT * FROM @NewTable

转载于:https://www.cnblogs.com/tianjinquan/p/4181709.html