sql server 2000 存储过程 CREATE PROCEDURE [dbo].[pro_insertip] @iphead varchar(15), @startIP int, @endIP int AS declare @insertIP int, @inputip as varchar(15) set @insertIP=@startip while @insertip<=@endip begin set @inputip=@iphead+cast(@insertip as varchar(2)) insert into table3(ip)values(@inputip) set @insertip=@insertip+1 end GO ---------------------------- exec pro_insertip '192.168.9.','4','46'即可将从192.168.9.4到192.168.9.46插入数据库
然后用JAVA来调用这个存储过程
CREATE PROCEDURE [dbo].[pro_insertip]
@iphead varchar(15),
@startIP int,
@endIP int
AS
declare @insertIP int,
@inputip as varchar(15)
set @insertIP=@startip
while @insertip<=@endip
begin
set @inputip=@iphead+cast(@insertip as varchar(2))
insert into table3(ip)values(@inputip)
set @insertip=@insertip+1
end
GO
----------------------------
exec pro_insertip '192.168.9.','4','46'即可将从192.168.9.4到192.168.9.46插入数据库