MSSQL中取得计算机名

ALTER       FUNCTION S_GetComputerName()
RETURNS varchar(50)
AS  
BEGIN
    declare @returnvalue varchar(50)
    select  @returnvalue = hostname from master..sysprocesses where spid = @@spid
    Return(Rtrim(@returnvalue))
END