/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

1 vote230 views1 answer
How to show index type in postgresql
SQL
1 vote242 views1 answer
Connect to mysql database ubuntu
SQL
0 vote170 views1 answer
How to use sqlcommand
SQL
0 vote166 views1 answer
Mysql workbench view
SQL
0 vote251 views1 answer
Sql delete row from table where id
SQL
3 votes177 views1 answer
Mysql insert on dupèlicate
SQL
0 vote180 views1 answer
Select amount weeks between two dates mysql
SQL
0 vote166 views3 answers
Get free card roblox
SQL
2 votes170 views1 answer
Oracle index size
SQL
1 vote152 views1 answer
Stop mysql server mac
SQL