SQL reads the running Port Number of SQL Server.

/*
-- SQL reads the running Port Number of SQL Server
-- Original post posted in http://community.csdn.net/Expert/topic/4315/4315806.xml? Temp =. 9091913.

-- Vivianfdlpw 2005.10.27 reference please keep this information
*/

Declare @ port varchar (20)
Exec master .. xp_regread @ rootkey = 'HKEY _ LOCAL_MACHINE'
, @ Key = 'Software/Microsoft/MSSQLServer/supersocketnetlib/tcp'
, @ Value_name = 'tcpport'
, @ Value = @ port output
Select @ Port

-- Result
/*
--------------------
1433

(The number of affected rows is 1)
*/