34,575
社区成员
发帖
与我相关
我的任务
分享
create procedure test_p
@ipAddress1 varchar(20) output,
@ipAddress2 varchar(20) output
as
begin
declare @a1 varchar(1000)
declare @i int
set @i=1
while @i<=2
begin
set @a1='set @ipAddress'+convert(varchar(30),@i)+'='''+left(dbo.GetSplitOfIndex('162.168.0.1,192.168.0.2',',',@i), 20)+''''
print @a1
exec(@a1)
set @i=@i+1
end
end
declare @ip1 varchar(20)
declare @ip2 varchar(20)
exec test_p @ip1 output,@ip2 output
set @a1='DECLARE @IPADDRESS VARCHAR(100)
set @ipAddress'+convert(varchar(30),@i)+'='''+left(dbo.GetSplitOfIndex('162.168.0.1,192.168.0.2',',',@i), 20)+''''