- CREATE FUNCTION [dbo].[GetCurrentIP] ()
- RETURNS varchar(255)
- AS
- BEGIN
- DECLARE @IP_Address varchar(255);
- SELECT @IP_Address = client_net_address
- FROM sys.dm_exec_connections
- WHERE Session_id = @@SPID;
- Return @IP_Address;
- END
- --该片段来自于http://www.codesnippet.cn/detail/210220132168.html
来源: http://www.codesnippet.cn/detail/210220132168.html