/SQL/How to find sql server installation folder

How to find sql server installation folder

declare @rc int, @dir nvarchar(4000) 

exec @rc = master.dbo.xp_instance_regread
      N'HKEY_LOCAL_MACHINE',
      N'Software\Microsoft\MSSQLServer\Setup',
      N'SQLPath', 
      @dir output, 'no_output'
select @dir AS InstallationDirectory

Source: stackoverflow.com

Similar codes

1 vote126 views1 answer
Oracle aleter trigger ora-01031
SQL
1 vote90 views1 answer
Oracle character set
SQL
10 votes128 views1 answer
Dba_dependencies
SQL
4 votes140 views1 answer
Oracle user tables
SQL
1 vote119 views1 answer
Oracle finding duplicate records
SQL
0 vote87 views1 answer
Oracle list all stored procedures
SQL
1 vote135 views1 answer
Spark sql concatenate string and int
SQL
24 votes141 views4 answers
Mssql get all table names
SQL
0 vote145 views1 answer
Laravel migration sql dump
SQL
0 vote137 views1 answer
Mysql date format unix timestamp
SQL