本文展示了一个使用SQL语句进行日期循环并批量插入记录的例子。通过声明变量和使用while循环，实现了从指定起始日期到结束日期之间的每一天都有数据被插入到数据库表中。
declare @num int
declare @datediff int
select @datediff=datediff(day,'2007-12-12','2008-9-10)
set @num=0
while @num<@datediff
begin
insert into cms_count values('192.168.1.174','1','狗狗',' http://gougou.com/ ','1280*780','IE','Vasta',' www.163.com ',dateadd(day,@num,'2007-12-12') )
set @num=@num+1
end
declare @datediff int
select @datediff=datediff(day,'2007-12-12','2008-9-10)
set @num=0
while @num<@datediff
begin
insert into cms_count values('192.168.1.174','1','狗狗',' http://gougou.com/ ','1280*780','IE','Vasta',' www.163.com ',dateadd(day,@num,'2007-12-12') )
set @num=@num+1
end
扫一扫
3803
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
