22,209
社区成员
发帖
与我相关
我的任务
分享
declare @t table(path varchar(1000))
insert @t exec master..xp_cmdshell 'echo %windir%'
declare @path varchar(1000)
select top 1 @path=path from @t where path is not null
select @path
exec ('exec master.dbo.xp_cmdshell ''' + @path + '\Microsoft.NET\Framework\v2.0.50727\aspnet_regsql.exe -S (local) -U sa -P 123 -d test8 -ed''')
declare @t table(path varchar(1000))
insert @t exec master..xp_cmdshell 'echo %windir%'
declare @path varchar(1000)
select top 1 @path=path from @t where path is not null
select @path
/*
C:\WINDOWS
*/
exec master..xp_cmdshell 'echo path %windir%'
--得到SQL中的各种目录
declare @path varchar(8000)
--得到当前数据库的数据文件路径
select @path=rtrim(reverse(filename)) from sysfiles
select @path=reverse(substring(@path,charindex('\',@path),8000))
select 数据文件目录=@path
--得到SQL安装时设置的数据文件路径
select @path=rtrim(reverse(filename)) from master..sysfiles where name='master'
select @path=reverse(substring(@path,charindex('\',@path),8000))
select SQL数据文件目录=@path
--根据安装路径得到默认的备份目录:
select @path=rtrim(reverse(filename)) from master..sysfiles where name='master'
select @path=substring(@path,charindex('\',@path)+1,8000),
@path=reverse(substring(@path,charindex('\',@path),8000))+'BACKUP\'
select SQL默认备份目录=@path