/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

11 votes111 views2 answers
Turn off safe mode mysql
SQL
0 vote61 views1 answer
Mysql date + 1 day
SQL
27 votes117 views6 answers
Sql update record
SQL
2 votes102 views1 answer
Oracle generated column
SQL
0 vote120 views1 answer
Command to give readonly access to a postgres sql user
SQL
11 votes102 views3 answers
How to get last row of table in sql
SQL
21 votes113 views6 answers
Update sql
SQL
0 vote164 views1 answer
Tsql find procedure with name
SQL
0 vote94 views1 answer
QCompleter con sql
SQL
0 vote102 views1 answer
Oracle job schedules
SQL