添加学校用户时。。。添加IP段0-255手动

declare @i int set @i=0 
while(@i<255) 
begin  
set @i=@i+1  
insert into sy_unitIPs(school_ID,IP,endTime,isTryout) values('01001200902250272024','58.129.31.'+cast(@i as varchar),'2009-3-25',1) 

end

posted @ 2009-02-26 21:26  ChaunceyHao  阅读(201)  评论(0)    收藏  举报