CREATE PROCEDURE Test3
AS
BEGIN
DECLARE @ReadReg varchar(1000)
Declare @outputdata varchar(255)
Declare @outputstr varchar(255)
EXEC master..xp_regread @rootkey='HKEY_LOCAL_MACHINE',
@key='SOFTWARE\Canon\CanoBureau Workgroup\Registration',
@value_name='DataDir',
@value=@ReadReg OUTPUT
SELECT @ReadReg = @ReadReg + '\Log\logfile.txt'
print @ReadReg
select @outputdata = 'あいうえお'
select @outputstr = 'echo ' + @outputdata + ' >> "' + @ReadReg + '"'
exec master..xp_cmdshell @outputstr
end
GO
SQLSERVERのログ
AS
BEGIN
DECLARE @ReadReg varchar(1000)
Declare @outputdata varchar(255)
Declare @outputstr varchar(255)
EXEC master..xp_regread @rootkey='HKEY_LOCAL_MACHINE',
@key='SOFTWARE\Canon\CanoBureau Workgroup\Registration',
@value_name='DataDir',
@value=@ReadReg OUTPUT
SELECT @ReadReg = @ReadReg + '\Log\logfile.txt'
print @ReadReg
select @outputdata = 'あいうえお'
select @outputstr = 'echo ' + @outputdata + ' >> "' + @ReadReg + '"'
exec master..xp_cmdshell @outputstr
end
GO
SQLSERVERのログ