TSQL to find if server is listening on dynamic or static port

Using TSQL, how can I find if the MS SQL server (any version) is configured to use static port or is it using dynamic port? Script i am trying to use: DECLARE @TcpPort VARCHAR(5) ,@RegKey VARCHAR(100) IF @@SERVICENAME !='MSSQLSERVER' BEGIN SET @RegKey = 'SOFTWARE\Microsoft\Microsoft SQL Server\' + @@SERVICENAME + '\MSSQLServer\SuperSocketNetLib\Tcp\IPAll' END ELSE BEGIN SET @RegKey = 'SOFTWARE\MICROSOFT\MSSQLSERVER\MSSQLSERVER\SUPERSOCKETNETLIB\TCP\IPAll' END EXEC master..xp_regread @rootkey = 'HKEY_LOCAL_MACHINE' ,@key = @RegKey ,@value_name = 'TcpPort' ,@value = @TcpPort OUTPUT EXEC master..xp_regread @rootkey = 'HKEY_LOCAL_MACHINE' ,@key = @RegKey ,@value_name = 'TcpDynamicPorts' ,@value = @TcpPort OUTPUT SELECT @TcpPort AS PortNumber ,@@SERVERNAME AS ServerName ,@@SERVICENAME AS ServiceName