/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 vote387 views1 answer
Postgres list tables and row counts
SQL
3 votes347 views2 answers
Df to sql pandas sql achemy
SQL
1 vote351 views1 answer
Get all db sizes in mysql server
SQL
1 vote325 views2 answers
Sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) unable to open database file
SQL
5 votes364 views2 answers
Umgebungsvariable setzen für mysql 8
SQL
1 vote448 views2 answers
Begin transaction sql
SQL
92 votes635 views6 answers
Substring
SQL
3 votes345 views1 answer
Oracle revoke grant
SQL
1 vote384 views1 answer
Alter constraint in sql
SQL
2 votes390 views3 answers
Xampp mysql database not starting
SQL