如何用sql命令获取ip地址 - MS-SQL Server / 应用实例

如何用sql命令获取当前数据库服务器的ip地址

---

学习，帮顶

---

SQL code:
exec master..xp_cmdshell 'ipconfig'

---

SQL code:
SELECT @@SERVERNAME

---

SQL code:
create Procedure sp_get_ip_address (
@ip varchar(40) out
)
as
begin
Declare @ipLine varchar(200)
Declare @pos int
set nocount on
set @ip = NULL
Create table #temp (ipLine varchar(200))
Insert #temp exec master..xp_cmdshell 'ipconfig'
select @ipLine = ipLine from #temp where upper (ipLine) like '%IP ADDRESS%'
if (isnull (@ipLine,'***') != '***')
begin
set @pos = CharIndex (':',@ipLine,1);
set @ip = rtrim(ltrim(substring (@ipLine ,@pos + 1 ,len (@ipLine) - @pos)))
end
drop table #temp
set nocount off
end
go
declare @ip varchar(40)
exec sp_get_ip_address @ip out print @ip

---

SQL code:
create table #tmp(aa varchar(200))
insert #tmp exec xp_cmdshell 'ipconfig'
select s