sqlserver select IP address

SELECT client_net_address as a1, local_net_address as a2
FROM sys.dm_exec_connections
WHERE session_id = @@SPID