添加学校用户时。。。添加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
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
浙公网安备 33010602011771号