/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

0 vote224 views1 answer
Uuid sqlalcomany
SQL
4 votes239 views1 answer
Oracle error line
SQL
0 vote225 views1 answer
Copy data from cell to cell mysql
SQL
0 vote209 views1 answer
How to fetch highest score in minimum time using mysql
SQL
0 vote272 views1 answer
Insert into using contant values and source table columns with sql
SQL
0 vote241 views1 answer
Illuminate\Database\QueryException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'updated_at' in 'field list'
SQL
3 votes228 views1 answer
Ssh check mysql version
SQL
0 vote234 views1 answer
Top frequency in sql server
SQL
7 votes216 views3 answers
Postgre describe table
SQL
16 votes240 views4 answers
Ascending order mysql
SQL