/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 vote212 views1 answer
See Foreign Key
SQL
0 vote209 views1 answer
Php mysqli install
SQL
0 vote205 views1 answer
Sql offfset
SQL
-1 vote231 views1 answer
An error occurred while installing mysql (2.9.1), and Bundler cannot continue
SQL
2 votes181 views2 answers
Get all columns from table sql
SQL
0 vote218 views1 answer
Sql #region
SQL
2 votes165 views4 answers
Mysql change database character set to utf8mb4
SQL
0 vote207 views1 answer
How to reset the database value in SQL server
SQL
1 vote253 views1 answer
Add time to date sql
SQL
0 vote303 views1 answer
Sql to search who modified
SQL