SELECT    @@SERVERNAME as [@@SERVERNAME], SERVERPROPERTY('MachineName') MachineName, SERVERPROPERTY('InstanceName') InstanceName, SERVERPROPERTY('ServerName') ServerName,

        SERVERPROPERTY('ComputerNamePhysicalNetBIOS') PhysicalNetBIOS

@@SERVERNAME    　　　　　　MachineName    　　InstanceName    　　ServerName    PhysicalNetBIOS

JerryPC\MSSQLSERVER2014　　JerryPC　　　　　　MSSQLSERVER2014 　　JerryPC　　　　JerryPC