如何获取SQL安装路径 - MS-SQL Server / 基础类

RT

---

SQL code:
select * from sysfiles

---

SQL code:
select filename from sysfiles

---

邮件->属性->查找目标。勿见笑

---

SQL code:
use master

select * from sysfiles


看看就差不多了

---

从注册表应该是准确的，从数据库里查出的与数据库安装路径有关

---

引用

SQL code
select filename from sysfiles

up

---

SQL code:
declare @s varchar(20)
set @s=DB_NAME()
exec sp_helpdb @s

---

SQL code:
master..xp_instance_regread N'HKEY_LOCAL_MACHINE', N'SOFTWARE\Microsoft\MSSQLServer\Setup', N'SQLPath'