如何得到SQL Server的安装路径?

如何得到SQL Server的安装路径?

---------------------------------------------------------------

方法1:
declare @path varchar(200)
exec master.dbo.xp_regread
'HKEY_LOCAL_MACHINE',
'SOFTWARE\Microsoft\MSSQLSERVER\setup',
'SQLPath',@path output
set @path = @path + '\data'
print @path

方法2:
declare @path varchar(200)
select @path = filename from master.dbo.sysfiles
set @path = ltrim(REVERSE(@path))
set @path = REVERSE(substring(@path,CHARINDEX('',@path),len(@path)))
print @path

Published At
Categories with 数据库类
Tagged with
comments powered by Disqus