T-SQL获取客户端机器名
declare @hostname nvarchar(200)
select @hostname = isnull(hostname, '')
from master..sysprocesses
where spid = @@spid
print @hostname
declare @hostname nvarchar(200)
select @hostname = isnull(hostname, '')
from master..sysprocesses
where spid = @@spid
print @hostname