sql-server – 从XP_CMDSHELL获取结果

专家交流：

No,xp_cmdshell will not return any information from the exe. and you have to use the following
syntax if you are not in the master database to run it. master..xp_cmdshell. You will have to
give your user permission to execute this procedure in the master database. You will have to have
your exe insert the information its self because it can not return information to the process that
called it.

和…

虽然@result仅从xp_cmdshell获取返回值,但您可能可以捕获结果
的命令直接插入到表中…这样的东西：

因人而异…

set nocount on
declare  @filepath   varchar(255),@cmd        varchar(255),@rc         int

select   @filepath = 'c:temp'         
select   @cmd      = 'dir ' + @filepath + '~*.tmp'

create table #output (output varchar(255) null)
insert #output exec @rc = master..xp_cmdshell @cmd
select * from #output where output is not null
drop table #output

解决方法

在上面发布的脚本中至少有一个错误. xp_cmdshell的文档表示它将命令输出返回为nvarchar(255).
此外,临时表应该有一个标识列,否则结果可能不会按正确的顺序显示：

...
create table #output (id int identity(1,1),output nvarchar(255) null)
insert #output (output) exec @rc = master..xp_cmdshell @cmd
select * from #output where output is not null order by id
drop table #output

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!