34,838
社区成员




declare @a0 nvarchar(1000)
declare @a1 nvarchar(max)
declare @i int
set @i=1
while @i<=2
begin
set @a0='declare @ip'+convert(nvarchar(30),@i)+' varchar(20) '
set @a1='@ip'+convert(varchar(30),@i)+'='+left(dbo.GetSplitOfIndex('192.168.0.1,192.168.0.2',',',@i), 20)
print @a1
exec(@a0+@a1)
set @i=@i+1
end
declare @a0 nvarchar(1000)
declare @a1 nvarchar(max)
declare @i int
set @i=1
while @i<=2
begin
set @a0='declare @ip'+convert(nvarchar(30),@i)+' varchar(20) '
set @a1='set @ip'+convert(varchar(30),@i)+'='''+left(dbo.GetSplitOfIndex('192.168.0.1,192.168.0.2',',',@i), 20)+''''
--set @a1=' set @ip'+convert(varchar(30),@i)+'=192.168.0.1'
print @a1
exec(@a0+@a1)
set @i=@i+1
end