/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

3 votes110 views2 answers
Df to sql pandas sql achemy
SQL
-1 vote117 views1 answer
How to dump .csv file into mysql
SQL
1 vote115 views1 answer
Pgsql sum switch case
SQL
0 vote105 views1 answer
Postgresql delete multiple rows
SQL
0 vote117 views1 answer
Mql5 datetime get hour
SQL
0 vote118 views3 answers
How to assign custom id in mysql
SQL
3 votes145 views3 answers
Cannot truncate a table referenced in a foreign key constraint
SQL
0 vote108 views2 answers
The metadata storage is not up to date, please run the sync-metadata-storage command to fix this issue.
SQL
0 vote105 views1 answer
Inserting values with beekeeper get error null value in column createdAt violates not-null constraint
SQL
6 votes117 views4 answers
Remove spaces sql server
SQL