SQL statement that can get the IP address of the client _mssql

--1: Get the client's IP address
/************* IP **************/
DECLARE @ip varchar (varchar), @hst (a), @sql varchar (100)
DECLARE @str varchar (100)
Set @str = ' PING ' +host_name ()
CREATE TABLE #tmp (AA varchar (200))
Insert #tmp exec master. xp_cmdshell @str
Select top 1 @ip = replace (Aa,charindex (': ', AA)-1), ' Reply from ', '
From #tmp where AA is like ' Reply from%:% '
drop table #tmp
Select @ip


--2: Get the physical address of the network card
CREATE table #tb (re varchar (255))
INSERT into #tb exec master. xp_cmdshell ' Ipconfig/all '

Select Network Card Physical Address =substring (Re,charindex (': ', re) +1,255) from #tb where re like '%physical addresses ... . :%'

drop table #tb
Go


--3: Converts the IP address segment to every three digits, separated by dots
Create function GetIP (@a varchar (15))
Returns varchar (15)
As
Begin
DECLARE @s varchar (15)
Set @s = '
While CHARINDEX ('. ', @a) > 0
Begin
Set @s = @s + Right ("+" + Left (@a,charindex ('. ', @a)), 4)
Set @a = Right (@a,len (@a)-charindex ('. ', @a))
End
Set @s = @s + right (' + ' + @a,3)
Return @s
End

/*
Select dbo.getip (' 202.1.110.2 ')
---------------
202.001.110.002

(The number of rows affected is 1 rows)
*/
--drop function GetIP