SQL Server中的循环例子（网摘）

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

 

摘自：http://zhidao.baidu.com/question/281897122.html&__bd_tkn__=7aa6485d3a2499274a6dae73fae724b4da5fcbeaa72b33d654bdac4c7db387c67f35cb62bbe1d86322bf7e11a1fbf821ddf321b022