Search
 
SCRIPT & CODE EXAMPLE
 

SQL

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'SoftwareMicrosoftMSSQLServerSetup',
      N'SQLPath', 
      @dir output, 'no_output'
select @dir AS InstallationDirectory
Comment

PREVIOUS NEXT
Code Example
Sql :: select count distinct multiple columns sql server 
Sql :: sql highest salary by location 
Sql :: changing name of column and datatype in sql 
Sql :: How do I UPDATE from a SELECT in SQL Server? 
Sql :: oracle step procedure 
Sql :: oracle cpu metric 
Sql :: SQL isnumeric DB2 
Sql :: last 2 mins sql server 
Sql :: how to check which table has data in mysql 
Sql :: oracle list user locked 
Sql :: what is drop in sql 
Sql :: date datatype in livesql 
Sql :: windows aggregate functions in postgresql 
Sql :: how to get second highest salary in each department in sql 
Sql :: insert query in oracle 
Sql :: delete account in flask and sqlalchemy 
Sql :: tablo silme SQL 
Sql :: homebrew mysql service not starting 
Sql :: mysql even numbers 
Sql :: longtext sql 
Sql :: sql asc 
Sql :: difference between left outer join and left join in sql 
Sql :: psql: error: FATAL: database "odoo" does not exist 
Sql :: create a database mysql 
Sql :: timestamp(0) postgresql 
Sql :: sql server get week dates from week number 
Sql :: Concatenate columns in table 
Sql :: SQL SMALLDATETIME Data Type 
Sql :: what is 1=2 in sql 
Sql :: com.mysql.jdbc.exceptions.MySQLNonTransientConnectionException: Client does not support authentication protocol requested by server; consider upgrading MySQL client 
ADD CONTENT
Topic
Content
Source link
Name
8+9 =