Determine Active Node in SQL Failover Cluster

Displays the active server node:

Select ServerProperty('ComputerNamePhysicalNetBIOS')

Whether the server is clustered:

SELECT SERVERPROPERTY('IsClustered')