/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

4 votes324 views6 answers
Second max salary in sql
SQL
4 votes303 views1 answer
Oracle error compilation line
SQL
2 votes312 views1 answer
Oracle drop table free up space
SQL
1 vote312 views2 answers
Last working day in week date function in sql
SQL
0 vote314 views1 answer
Convert .mdf to .bak
SQL
1 vote322 views3 answers
Sql server get week dates from week number
SQL
3 votes322 views2 answers
Find the median in sql
SQL
1 vote321 views1 answer
How to select the nth row in a SQL database table?
SQL
0 vote317 views1 answer
Alasql delete column
SQL
0 vote333 views1 answer
Dump only data
SQL