/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

17 votes355 views3 answers
Postgresql version command
SQL
0 vote358 views1 answer
Sql count null values in all columns
SQL
0 vote381 views1 answer
Mysql installer did not find packages in the current bundle suitable for installation
SQL
0 vote329 views1 answer
Sql developer format sql
SQL
0 vote396 views1 answer
Stored procedure function relation
SQL
1 vote379 views2 answers
How to install sql server management studio in ubuntu 18.04
SQL
2 votes351 views3 answers
Postgresql reset auto increment
SQL
0 vote367 views1 answer
Sql period overlap
SQL
0 vote379 views1 answer
Mysql multiple group by
SQL
0 vote366 views1 answer
Oracle tablespace autoextend
SQL