SQL 在一个时间段内每天插入一条记录

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