/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

8 votes152 views1 answer
Similarities between ddl and dml
SQL
8 votes209 views2 answers
How to fetch data from database without last column
SQL
3 votes188 views1 answer
Oracle apex call duration
SQL
0 vote186 views1 answer
Show size of all tables postgres
SQL
0 vote185 views1 answer
Sqlalchemy.exc.OperationalError:
SQL
0 vote196 views1 answer
How to add more columns to a table in mysql
SQL
9 votes193 views6 answers
Sql insert into
SQL
0 vote216 views1 answer
What is initial catalog in sql connection string
SQL
1 vote184 views2 answers
Postgresql list columns
SQL
0 vote182 views1 answer
Drop all tables db2
SQL