斗胆问个问题：SQL中如何求服务器IP？

EventArgs

学习ing……

hongtao2000

最初由 magicangel 发布
[B]以上在Sqlserver2000里验证通过 [/B]

how to get host name when you know the ip address?

magicangel

此proc只能取得局域网内的host name
--drop proc gethostname
create procedure Gethostname
(@gethost varchar(30))
as
begin

create table #m(demo varchar(500))
declare @sql varchar(99),@b int,@c varchar(50)

select @c='master..xp_cmdshell '+''' tracert '''
select @b=charindex('rt',@c,1)
select @sql=stuff(@c,@b+3,0,@gethost)--取得类似master..xp_cmdshell 'tracert target'的效果

insert into #m exec(@sql)

declare @s varchar(99),@ip varchar(24),@p int,@l int,@a int

select @s=rtrim(ltrim(demo)) from #m where demo like '%tracing%'
select @l=len(@s),@p=charindex('to',@s,2) ,@a=charindex('[',@s,1)
select @ip=rtrim(ltrim(substring(@s,@p+2,(@a-@p-2))))
select @ip as '主机名'

drop table #m

end

--exec gethostname '10.1.118.228'
--在sqlserver2000中验证通过。

tiger_zyj

好帖子，顶！

iamseraph

顶