获取服务器名字和SQL SERVER实例名的几种函数

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