Question

SQL Server for循环

insert into cms_count values('192.168.1.174','1','狗狗','http://gougou.com/','1280*780','IE','Vasta','www.163.com','2007-12-12')

时间要更改
我要循环插入。插到.2008-9-10 . 是

在SQL查询分析器里面怎么插入

Answer 1

你是每天插一条这样的数据吗

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