DECLARE @HkeyLocal nvarchar(18)

 DECLARE @Instance varchar(100)

 DECLARE @MSSqlServerRegPath nvarchar(200)

 DECLARE @PortNumber varchar(100)

 --For Named instance

 --SET @Instance ='MSSQL13.SQL01'

 SET @Instance ='MSSQL13.MSSQLSERVER'

 SET @HkeyLocal=N'HKEY_LOCAL_MACHINE'

 SET @MSSqlServerRegPath=N'SOFTWARE\Microsoft\\Microsoft SQL Server\'+ @Instance + '\MSSQLServer\SuperSocketNetLib\Tcp\IPAll'

 Print @MSSqlServerRegPath

 EXEC xp_instance_regread @HkeyLocal

 , @MSSqlServerRegPath

 , N'TcpPort'

 , @PortNumber OUTPUT

 SELECT @PortNumber as [Port Number]

 --OUTPUT

     • 读取instanceHide在注册表中的值

 DECLARE @Instance varchar(100)

 set @Instance='MSSQLServer'

 DECLARE @MSSqlServerRegPath nvarchar(200)

 set @MSSqlServerRegPath=N'SOFTWARE\Microsoft\Microsoft SQL Server\'+@Instance+ N'\SuperSocketNetLib'

 print @MSSqlServerRegPath

 DECLARE @getValue INT

 EXEC master..xp_instance_regread

 @rootkey = N'HKEY_LOCAL_MACHINE',

 @key=@MSSqlServerRegPath,

 @value_name = N'HideInstance',

 @value = @getValue OUTPUT

 SELECT @getValue as HideInstance

 ----测试对命名实例读取instanceHide

 DECLARE @HkeyLocal nvarchar(18)

 DECLARE @Instance varchar(100)

 DECLARE @MSSqlServerRegPath nvarchar(200)

 DECLARE @PortNumber int

 --For Named instance

 --SET @Instance ='MSSQL13.SQL01'

 SET @Instance ='MSSQL13.MSSQLSERVER'

 SET @HkeyLocal=N'HKEY_LOCAL_MACHINE'

 SET @MSSqlServerRegPath=N'SOFTWARE\Microsoft\\Microsoft SQL Server\'+ @Instance + '\MSSQLServer\SuperSocketNetLib'

 Print @MSSqlServerRegPath

 EXEC xp_instance_regread @HkeyLocal

 , @MSSqlServerRegPath

 , N'HideInstance'

 , @PortNumber OUTPUT

 SELECT @PortNumber as [Port Number]

 --OUTPUT