DECLARE @i datetime
SET @i=‘2018-06-01 00:00:00.000’
WHILE @i<‘2019-10-21 00:00:00.000’
BEGIN
INSERT INTO *** ( [date], worktime,powerontime,worktime_rate,powerontime_rate,rate) —xx为表名
VALUES ( @i,0,0,0,0,0)
SET @i=DATEADD(DAY,1,@i)
END
SQL 循环插入重复数据
最新推荐文章于 2023-01-05 20:11:12 发布